Hi,

To find the status of all objects use the following query:

select object_name, object_type, status from all_objects
where owner = 'Your_Owner'
order by 1,2;

To check the status of constraints, you can use the query:

select constraint_name, constraint_type, status
from all_constraints
where owner = 'Your_owner'
order by constraint_name

To get the names of all Primary & foreign key constraints existing, you can use:(provided the constraint names are prefixed/suffixed by PK/FK)

select table_name|| ' | ' || column_name|| ' | ' || constraint_name from all_cons_columns
where owner = 'Your_Owner'
and constraint_name like '%K%'
order by table_name


Hope this will help you to get started.

Good Luck
Prasad.