Truncate Qs

From: Prabal Biswas <willsm_at_hotmail.com>
Date: Tue, 20 Jun 2000 19:03:21 GMT
Message-Id: <10534.109894@fatcity.com>

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 Received on Tue Jun 20 2000 - 14:03:21 CDT