Re: Can't drop column
Date: Tue, 28 Jul 2009 16:44:45 GMT
On Tue, 28 Jul 2009 22:24:12 +0500, "Sicilian Dragon" <e4c5Nf3g6_at_sicilian.com> wrote:
>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
Have you checked if if the column is being referenced by other tables?
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We use RMAN and remote catalog for backups Received on Tue Jul 28 2009 - 11:44:45 CDT