Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: l.armbruester@vertriebsunion.de (=?ISO-8859-1?Q?Lothar_Armbr=FCster?=)
Newsgroups: comp.databases.oracle.server
Subject: ora-00001 while dropping unused columns
Date: 3 Mar 2003 01:17:44 -0800
Organization: http://groups.google.com/
Lines: 17
Message-ID: <35559896.0303030117.11f72da6@posting.google.com>
NNTP-Posting-Host: 62.157.88.194
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1046683064 29701 127.0.0.1 (3 Mar 2003 09:17:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Mar 2003 09:17:44 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178227
X-Received-Date: Mon, 03 Mar 2003 02:17:37 MST (news.easynews.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