Skip to Main Content

Oracle Database Discussions

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!

ORA-00001: unique constraint SYS.I_COL1 violated

887010Sep 8 2011 — edited Sep 9 2011
Hi Guys,

When I am trying drop cloumns from table I am getting below mentiond query.

Can any one please help me out in this.

Version : 10.2.0.2

Query :

alter table toools_data drop (FREI_CALC_METH, FREI_CALC_VOL, FREI_CALC_WEI, FREI_ZONE);

Error:

ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint SYS.I_COL1 violated
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2011
Added on Sep 8 2011
12 comments
12,674 views