oracle dependencies table
-- Dependencies on a view, table, ... SELECT * FROM ALL_DEPENDENCIES -- or DBA_DEPENDENCIES or USER_DEPENDENCIES WHERE TYPE = 'VIEW' -- or 'PROCEDURE', 'SYNONYM'... AND REFERENCED_OWNER = 'OBJECT_OWNER' AND REFERENCED_NAME = 'OBJECT_NAME';