| 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
Thanks Scott,
I was just wondering if there is no data in the table, then also why should
truncate table give the error.
From: "Scott Shafer" <scott.shafer_at_ildmail.com>
To: <willsm_at_hotmail.com>
Subject: Re: Truncate Qs
Date: Tue, 20 Jun 2000 14:40:33 -0500
truncate table <tabname> cascade constraints;
> 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
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Prabal Biswas
> INET: willsm_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
 |
 |