How to find foreign-key dependencies pointing to one record in Oracle?
Posted
by daveslab
on Stack Overflow
See other posts from Stack Overflow
or by daveslab
Published on 2010-03-24T16:36:04Z
Indexed on
2010/03/24
17:03 UTC
Read the original article
Hit count: 191
Hi folks,
I have a very large Oracle database, with many many tables and millions of rows. I need to delete one of them, but want to make sure that dropping it will not break any other dependent rows that point to it as a foreign key record. Is there a way to get a list of all the other records, or at least table schemas, that point to this row? I know that I could just try to delete it myself, and catch the exception, but I won't be running the script myself and need it to run clean the first time through.
I have the tools SQL Developer from Oracle, and PL/SQL Developer from AllRoundAutomations at my disposal.
Thanks in advance!
© Stack Overflow or respective owner