Gunther Oracle APEX und Datenbank Wiki

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

Lösung:

  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