Can't drop column
Date: Tue, 28 Jul 2009 22:24:12 +0500
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