Hi Trina,
The following script will compile all ur database objects ie.. PROCEDURE,PAckage,package body,function,trigger

Enter the follwing select command to get inf about all the database obejcts which are invalid
select owner,object_name,object_type,status from
dba_objects where status='INVALID';


spool c:\x\allcompile.sql
select 'ALTER '||object_type ||' '||owner||'.'||object_name||' '|| 'COMPILE;'
from dba_objects where status='INVALID';
spool off

After running the above script ,run the allcompile.sql script to compile all the invalid objects.


Now regarding ur constraints,u can check it from dba_constraints.
U can fire the following query to get all the information about the constraint

select a.owner,b.column_name,b.constraint_name,decode(a.constraint_type,'C','Check','P','Primary',
'U','Unique','R','Referential')"Constraint Type",a.search_condition
from dba_constraints a,dba_cons_columns b
where a.table_name=upper('&table') and a.owner='CIIM86' and
a.constraint_name=b.constraint_name;


In case of any help needed please be free to ask me at [email protected]

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]