Can't drop column
From: Sicilian Dragon <e4c5Nf3g6_at_sicilian.com>
Date: Tue, 28 Jul 2009 22:24:12 +0500
Message-ID: <h4n8rc$d6l$1_at_news.eternal-september.org>
we're running this statement from a VB program
Date: Tue, 28 Jul 2009 22:24:12 +0500
Message-ID: <h4n8rc$d6l$1_at_news.eternal-september.org>
we're running this statement from a VB program
ALTER TABLE MyTable DROP COLUMN MyCol
However I get an error.
ORA-00604: error occured at recursive SQL level 1 ORA-00001: unique constraint (SYS.I_COL_USAGE$) violated
No indexes/constraints have been created on this column (MyCol) I've searched this error on google and it seems many people have been troubled by this however nowhere did I find a satisfactory answer. Received on Tue Jul 28 2009 - 12:24:12 CDT