Checking For Table Dependencies in Oracle.

The following query shows all the tables that have Column names as XXXXX and YYYYYY and the Schema owner is DB1.

SELECT *

FROM ALL_TAB_COLUMNS

WHERE COLUMN_NAME IN ('XXXXX','YYYYYY')

AND OWNER = 'DB1'

;