Return
-
Title
Doing schema compare generates invalid create synonym statements. Compare is including synonyms b -
Description
I am running a schema compare in Toad. I choose to run a compare of UserA and UserB. The compare seems to work for most objects, but it is picking up a difference regarding synonyms and creating sync files to adjust for this.
The problem is that these synonyms do not belong to either of the users. It is referenced in UserA, but the synonym does not be belong to either UserA or UserB. It belongs to UserC. Why is Toad including these synonyms as a difference and in the sync scripts? -
Resolution
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Oracle. -
Defect ID
ST60561