Got this query from this blog: http://www.dba-oracle.com/t_find_all_references_to_oracle_table.htm
select * from all_constraints
where r_constraint_name in
(select constraint_name from all_constraints
where table_name='TABLE_NAME');
No comments:
Post a Comment