Multiple Drop Constraint Statements Generated by SCO...
mbruegel
Posts: 43 Bronze 2
I'm seeing multiple drop constraint statements generated by schema compare for Oracle (5.1) command line.
I have a FK constraint w/ 2 columns. The source does not have the FK constraint, and the target does (i.e. the constraint should be dropped on the target).
The deployment fails (exit code 62) and the error message indicates that a non-existing constraint cannot be dropped.
Then I look at the captured update SQL, I see the same drop constraint appearing twice, immediately following the it's initial occurrence (which explains why Oracle throws an error.)
e.g.
Why does SCO generate the same drop statement multiple times, is there a fix available for this issue?
I have a FK constraint w/ 2 columns. The source does not have the FK constraint, and the target does (i.e. the constraint should be dropped on the target).
The deployment fails (exit code 62) and the error message indicates that a non-existing constraint cannot be dropped.
Then I look at the captured update SQL, I see the same drop constraint appearing twice, immediately following the it's initial occurrence (which explains why Oracle throws an error.)
e.g.
ALTER TABLE rg_dev1.item DROP CONSTRAINT item_fk01;
ALTER TABLE rg_dev1.item DROP CONSTRAINT item_fk01;
Why does SCO generate the same drop statement multiple times, is there a fix available for this issue?
Tagged:
Best Answer
-
Russell D
Posts: 1,324 Diamond 5
Hi @mbruegel I believe you've opened a support issue about this as well so we'll deal with this through that.
Have you visited our Help Centre?
Answers