===== Anzeige der per Foreign Key referenzierten Tabellen =====

Wie erkennt man bei einem "ORA-02449: unique/primary keys in table referenced by foreign keys" die abhängigen Tabellen?
\\

Lösung:
<code sql>
  SELECT table_name
        ,constraint_name
        ,status
        ,owner
    FROM all_constraints
   WHERE     r_owner = :ref_owner
         AND constraint_type = 'R'
         AND r_constraint_name IN (SELECT constraint_name
                                     FROM all_constraints
                                    WHERE constraint_type IN ('P', 'U') AND table_name = :ref_table_name AND owner = :ref_owner)
ORDER BY table_name, constraint_name
</code>
{{tag>sql script}}