How can we help you today? How can we help you today?

Multiple Drop Constraint Statements Generated by SCO...

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?
mbruegel
0

Comments

3 comments

  • Russell D
    Hi @mbruegel I believe you've opened a support issue about this as well so we'll deal with this through that.
    Russell D
    0
  • mbruegel
    Associated bug ID:  OC-1037
    mbruegel
    0
  • mbruegel
    Issue is resolved in release 5.2.5.1424
    mbruegel
    0

Add comment

Please sign in to leave a comment.