Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
ora-00001 while dropping unused columns
1 view
Skip to first unread message
Lothar Armbrüster
Mar 3, 2003, 4:17:44 AM3/3/03
to
Hello out there,
I have a table with approx. 100 rows. I set a column unused and am now
trying to drop it.
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
DA Morgan
Mar 3, 2003, 11:32:16 AM3/3/03
to
Lothar Armbrüster wrote:
I suspect you already have it. Bounce the database and try again. But
before you do read the alert logs and see if you can figure out what is
going wrong.
Daniel Morgan
Jusung Yang
Mar 3, 2003, 1:39:10 PM3/3/03
to
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.
upgrade to the current version or apply patch set. I would just
upgrade. Lots of nice features in 9i R2.
- Jusung Yang
l.armb...@vertriebsunion.de (Lothar Armbrüster) wrote in message news:<35559896.03030...@posting.google.com>...
0 new messages