Oracle - como saber a cuales tablas hace referencia una tabla

SELECT C.TABLE_NAME , C.CONSTRAINT_Name , CC.COLUMN_NAME "FK Column"

      FROM ALL_CONSTRAINTS C

      , All_Cons_colUMNs CC

      WHERE C.Constraint_Name = CC.Constraint_Name

      AND R_CONSTRAINT_NAME = ( SELECT CONSTRAINT_NAME

      FROM ALL_CONSTRAINTS

      WHERE TABLE_NAME = UPPER('pais')

      AND CONSTRAINT_TYPE = 'P'

     );

SELECT OWNER, TABLE_NAME, CONSTRAINT_NAME

FROM DBA_CONSTRAINTS  X

WHERE EXISTS (SELECT 1 FROM DBA_CONSTRAINTS

              WHERE TABLE_NAME=<nombre_tabla>

                AND OWNER=<Propietario_tabla>

                AND CONSTRAINT_TYPE='R'

                AND R_OWNER=X.OWNER

                AND R_CONSTRAINT_NAME=X.constraint_name)

AND CONSTRAINT_TYPE='P';

select O.NAME AS TABLA, C.NAME INDEX2,

B.NAME RELACION

from SYS.CDEF$ t,

     SYS.OBJ$ O,

     SYS.OBJ$ B,

     SYS.CON$ C

WHERE T.ROBJ# IS NOT NULL

AND T.OBJ# = O.OBJ#

AND T.ROBJ# = B.OBJ#

AND T.CON# = C.CON#

AND O.NAME = UPPER('NOMBRE_TABLA');