| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Truncate Qs
because constraints exist independent of data. If there are any foreign key
relationships, you need to use "cascade constraints" which tells the db to
ignore any key info...
--Scott
> Thanks Scott,
> I was just wondering if there is no data in the table, then also why
should
> truncate table give the error.
>
> To: <willsm_at_hotmail.com>
> Date: Tue, 20 Jun 2000 14:40:33 -0500
>
> truncate table <tabname> cascade constraints;
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, June 20, 2000 3:12 PM
>
>
> > Hello,
> > Can someone please explain me this:
> > I tried to truncate a table, it gave ORA-2266.
> > But when I deleted the rows, it did not show the error. And after
> deleting
> > the rown I tried to truncate the table again, but it still gives
ORA-2266
> >
> > TIA
> > Prabal
> >
> > SQL> truncate table supplier_order;
> > truncate table supplier_order
> > *
> > ERROR at line 1:
> > ORA-02266: unique/primary keys in table referenced by enabled foreign
> keys
> >
> > SQL> delete supplier_order;
> >
> > 97 rows deleted.
> >
> > SQL> truncate table supplier_order;
> > truncate table supplier_order
> > *
> > ERROR at line 1:
> > ORA-02266: unique/primary keys in table referenced by enabled foreign
> keys
> >
> >
 |
 |