Multiple Drop Constraint Statements Generated by SCO...

mbruegelmbruegel Philadelphia, PAPosts: 26 Bronze 1
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.
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?

Best Answer

Answers

Sign In or Register to comment.