-
How do I find out whether a primary key is referencing a foreign key in another table &, if so, which table is being referenced?
I need to do some index rebuilding & Oracle won't let me disable the contraint because it is referenced elsewhere in the database.
There seems v. little documentation in this area & I have no idea which dictionary tables to query.
cheers.
-
This might be what you are looking for:
select c.owner, c.constraint_name, c.constraint_type,
c.table_name
from dba_constraints c
where c.r_owner = 'owner of your constraint'
and c.r_constraint_name = 'name of your constraint';
HTH
David.
