Skip to Main Content

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!

can't drop a column

59876Sep 13 2002
I tried to drop a column from a table, alter table table1 drop column col1234;

But it return error,

ORA-00604: error occurred at recursive SQL Level 1
ORA-00001: unique constraint (SYS.I_COL_USAGE$) violated

Any idea what is going on??

I already drop all the indexes, constraints in this table (except primary key), but the column still can't be dropped!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2002
Added on Sep 13 2002
7 comments
2,096 views