Problems with Truncate Table

Hi,
I am using the Truncate command but it doesnt work, whereas delete works fine for the same table.

Here is what I am doing

SQL>Truncate table test;
Error at line 1:
ORA-02266:Unique/Primary Keys in table refernced by enabled foreign key.

But when i issue the following command it executes file

sql>delete from test;
100 rows deleted.

Can somebody point out the problem please.

Thanks
anurag

also reply at
anurag_at_synergy-infotech.com Received on Fri Sep 03 1999 - 04:02:02 CDT