Re: Can't drop column

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 28 Jul 2009 16:44:45 GMT
Message-ID: <8nau651h3carmfgsjvnkrbe3tp2g54tfg9_at_4ax.com>

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