Toad World® Forums

Compare Schemas flags includes all indexes if PK missing

Howdy,

In 12.11.0.62 Compare->Schemas, I have Constraints->PK, Indexes, and Grants checked with 30k+ differences (copying an ERP schema metadata). I noticed that even if a table has its indexes but the PK constraint is missing, all indexes are flagged to be created. On a 100K line script, that creates a LOT of ORA-955s. My script got blown away, but I also believe that it attempted to create all indexes twice – once for the indexes and another for the PK.

I think this is workaroundable by doing two compares. First, run with just the indexes, then run another with indexes and PKs, but deselecting the indexes on the script sync. If the PKs are selected without the indexes, the script has them incorrectly created, missing the “USING INDEX mytab.myindex” part.

Thanks!
Rich

Hi Rich,

I can reproduce that and will look at it. Another workaround is to also compare tables. In that case, my sync script just adds the constraints and counts the indexes as a match.

-John

Should be fixed next beta.

Awesome! Thanks, John!