SELECT TABLE_NAME FROM dba_CONSTRAINTS WHERE R_CONSTRAINT_NAME IN(
select CONSTRAINT_NAME from dba_CONSTRAINTS T
where table_name='TB_NC_MAIN_TMP' AND T.owner='GDSDKH'
)
SELECT TABLE_NAME FROM dba_CONSTRAINTS WHERE R_CONSTRAINT_NAME IN(
select CONSTRAINT_NAME from dba_CONSTRAINTS T
where table_name='TB_NC_MAIN_TMP' AND T.owner='GDSDKH'
)