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 14, 2015 by KinEspie
0 votes
12 views



Related Hot Questions



Government Jobs Opening


...