список constraint'ов, ссылающихся на таблицу

SQL> desc dba_constraints;
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------
 OWNER                                     NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                           NOT NULL VARCHAR2(30)
 CONSTRAINT_TYPE                                    VARCHAR2(1)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 SEARCH_CONDITION                                   LONG
 R_OWNER                                            VARCHAR2(30)
 R_CONSTRAINT_NAME                                  VARCHAR2(30)
 DELETE_RULE                                        VARCHAR2(9)
 STATUS                                             VARCHAR2(8)
 DEFERRABLE                                         VARCHAR2(14)
 DEFERRED                                           VARCHAR2(9)
 VALIDATED                                          VARCHAR2(13)
 GENERATED                                          VARCHAR2(14)
 BAD                                                VARCHAR2(3)
 RELY                                               VARCHAR2(4)
 LAST_CHANGE                                        DATE
 INDEX_OWNER                                        VARCHAR2(30)
 INDEX_NAME                                         VARCHAR2(30)
 INVALID                                            VARCHAR2(7)
 VIEW_RELATED                                       VARCHAR2(14)

SQL> desc dba_cons_columns;
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------
 OWNER                                     NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                           NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 COLUMN_NAME                                        VARCHAR2(4000)
 POSITION                                           NUMBER

Select B.constraint_name
From dba_constraints A, dba_constraints B
where A.constraint_name = B.r_constraint_name
  and A.table_name = '<имя таблицы>'

   SELECT /*+ ALL_ROWS*/
	 	  CC2.TABLE_NAME AS RTABLE_NAME
		  , CC2.COLUMN_NAME AS RCOLUMN_NAME
   FROM USER_CONS_COLUMNS CC
	    JOIN USER_CONSTRAINTS UC ON UC.R_CONSTRAINT_NAME = CC.CONSTRAINT_NAME
	    JOIN USER_CONS_COLUMNS CC2 ON UC.CONSTRAINT_NAME = CC2.CONSTRAINT_NAME
   WHERE CC.TABLE_NAME = 'ENENTITY'

SELECT * FROM Dba_Constraints dc
WHERE dc.constraint_type = 'R'
AND dc.r_constraint_name IN
    (SELECT dc1.constraint_name
     FROM Dba_Constraints dc1
     WHERE dc1.constraint_type IN ('P','U')
     AND upper(dc1.table_name) = 'T1')