_____________________________________________________________________________________

Global Docu:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_1045.htm#REFRN20045
http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_3120.htm#REFRN23047

_____________________________________________________________________________________

--> ORA-02292: Integritäts-Constraint (OWNER.BAD_CONSTRAINT_NAME) verletzt - untergeordneter Datensatz gefunden

set pages 1000
set lines 200

select
 coco2.constraint_name   || ':   *' ||
 coco1.owner             || '.' ||
 coco1.table_name        || '.' ||
 coco1.column_name       || '*   hat abhaengige Daten in   *' ||
 coco2.owner             || '.' ||
 coco2.table_name        || '.' ||
 coco2.column_name       ||
 '*'                     "STMT"
from
 dba_cons_columns coco1,
 dba_cons_columns coco2,
 dba_constraints  cons
where coco2.constraint_name  = 'BAD_CONSTRAINT_NAME'
  and coco2.constraint_name  = cons.constraint_name
  and coco1.constraint_name  = cons.r_constraint_name
;
_____________________________________________________________________________________