Re: Mandatory One to Many Constraint Problems

From: <nainm_at_my-deja.com>
Date: Thu, 03 Jun 1999 17:57:32 GMT
Message-ID: <7j6fm6$lla$1@nnrp1.deja.com>

In article <slrn7lcsuk.5mn.antares_at_antares.home.be>, antares_at_users.grmbl.com wrote:
> 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
>

That's correct. You can delete parent rows by disabling constraints but to drop table you've to drop constraints ...either by using cascade constraints or explicitly dropping them before dropping table.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 12:57:32 CDT