This is caused by bug #2144889 in your version of ORACLE. Either
upgrade to the current version or apply patch set. I would just
upgrade. Lots of nice features in 9i R2.
l.armbruester_at_vertriebsunion.de (Lothar Armbrüster) wrote in message news:<35559896.0303030117.11f72da6_at_posting.google.com>...
> Hello out there,
> I have a table with approx. 100 rows. I set a column unused and am now
> trying to drop it.
>
> SQL> alter table st_bediener drop unused columns;
> alter table st_bediener drop unused columns
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00001: unique constraint (SYS.I_COL_USAGE$) violated
>
> Do I have to worry about corruption? How can I fix this?
>
> It is Oracle 9.0.1.3.0 on W2k.
>
> Many thanks in advance,
> Lothar Armbrüster
Received on Mon Mar 03 2003 - 12:39:10 CST
