Re: a simple question about FKs

2002-06-18 Thread Igor Neyman
You did it right. It's just the way oracle works. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 9:43 AM > Hi. > > I was trying to truncate a table, which is a parent > to two ot

Re: a simple question about FKs

2002-06-18 Thread Alexandre Gorbatchev
Hi Gene, You cannot truncate a table that is a parent in enabled FK constraints. You did the right thing. or you can simply delete (of course longer) with enabled constraints. -- Alexandre > Hi. > > I was trying to truncate a table, which is a parent > to two other tables (its PK is referred to

RE: a simple question about FKs

2002-06-18 Thread Stephane Faroult
> >Hi. > >I was trying to truncate a table, which is a parent > >to two other tables (its PK is referred to by two >FKs >from two other tables). These "other" tables are >empty. >When I tried to truncate the parent table, however, >I >got an error message ORA-02266: unique/primary keys >in >table