Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Selecting list of foreign keys enabled on a table
I wish to truncate a table but I am getting a "ORA-02266: unique/primary
keys in table referenced by enabled foreign keys" message.
I understand why this is happening what I would like to know is how I can get a list of all foreign keys that are referencing the table I want to drop. I thought I had disabled all of them but there must be one eluding me.
Thanks in advance, Received on Wed Jul 22 1998 - 05:16:26 CDT
![]() |
![]() |