Organizational Research By

Surprising Reserch Topic

how to find foreign key dependencies pointing to one record in oracle


how to find foreign key dependencies pointing to one record in oracle  using -'database,oracle,database-schema'

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!
    

asked Sep 15, 2015 by JuanPalfreym
0 votes
25 views



Related Hot Questions

6 Answers

0 votes
NULL
answered Sep 15, 2015 by LeifFenneri
0 votes
NULL
answered Sep 15, 2015 by ChrWalsh
0 votes
NULL
answered Sep 15, 2015 by LinneaXADGjp
0 votes
NULL
answered Sep 15, 2015 by JaiPlain
0 votes
NULL
answered Sep 15, 2015 by AntonioDelat
0 votes
NULL
answered Sep 15, 2015 by Tanisha67Qd

...