SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop constraint still exists

529772Oct 24 2007 — edited Oct 24 2007

Hi,
I am dropping a constraint on a composite key as i want to add a new column to it. I succeded in dropping a column, but when i look into the ALL_CONS_COLUMNS table for it, it is not showing in this table but the same constraint is still in the all_constriants table and my application is throwing an ' UNIQUE CONSTRAINT' error.

FYI,We follow some conventions in naming the constraints and i have dropped it not the SYS_XXXXXXX constriant. Is this mandatory that we should drop SYS_XXXXXX constraints also????

Regards,
Nagarjun.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2007

Added on Oct 24 2007

3 comments

1,497 views