Re: Mandatory One to Many Constraint Problems

From: Bart Hanssens <antares_at_grmbl.com>
Date: 3 Jun 1999 16:24:57 GMT
Message-ID: <slrn7lcsuk.5mn.antares@antares.home.be>

On Mon, 31 May 1999 18:51:19 -0700, Douglas Shook wrote:
>DROP TABLE INV
> *
>ERROR at line 1:
>ORA-02266: unique/primary keys in table referenced by enabled foreign
>keys
>
>after I disabled all of the constraints on both tables. I know I am
>missing something here and would appreciate some help as to why Oracle
>7.3 will not let me drop the tables.

Quick & dirty: DROP TABLE INV CASCADE CONSTRAINTS;

My guess is disabling the constraints is not enough, I guess one must really drop the constraints.

greetings,

Bart Hanssens
--
c...because you can't build universes upon E = m COBOL^2 Received on Thu Jun 03 1999 - 11:24:57 CDT