Organizational Research By

Surprising Reserch Topic

Experts Most Trusted 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
23 views



Related Hot Questions



Government Jobs Opening


...