SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

finding foreign key which violates truncate

Ora_83Feb 9 2010 — edited Feb 9 2010

Hi

How can I find which foreign key is violationg trucate ? so that I will disable it

SQL> truncate table FLOWS_030000.WWV_FLOW_PAGE_PLUGS;
truncate table FLOWS_030000.WWV_FLOW_PAGE_PLUGS
                            *
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2010

Added on Feb 9 2010

9 comments

10,928 views