Return
-
Title
Error running Schema Compare Sync script results: "Constraint with this name already exists" -
Description
User runs a Schema Compare on two schemas which result on Table Columns differences. When he runs the generated sync script, the following error occurs:
"constraint with this name already exists".
There are no differences on the column constraints of the compared tables. This difference and generated code should not have been generated.
Â
-
Cause
One table constraint was created through the Create Table statement and the other created with an Alter Table statement.
-
Resolution
WORKAROUND:
Run Schema Compare and check only Constraints or only Tables to compare.STATUS:Waiting for fix to be released in a future version of Toad for Oracle. -
Defect ID
CR 73602