foreign/primary keys

[gareth]

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.

[Dave_A]

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.