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: JusungYang@yahoo.com (Jusung Yang)
Newsgroups: comp.databases.oracle.server
Subject: Re: ora-00001 while dropping unused columns
Date: 3 Mar 2003 10:39:10 -0800
Organization: http://groups.google.com/
Lines: 26
Message-ID: <130ba93a.0303031039.2595d5a8@posting.google.com>
References: <35559896.0303030117.11f72da6@posting.google.com>
NNTP-Posting-Host: 64.172.45.213
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1046716750 11327 127.0.0.1 (3 Mar 2003 18:39:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Mar 2003 18:39:10 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178288
X-Received-Date: Mon, 03 Mar 2003 11:39:04 MST (news.easynews.com)

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.


- Jusung Yang


l.armbruester@vertriebsunion.de (Lothar Armbrüster) wrote in message news:<35559896.0303030117.11f72da6@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