Parveeb Ahuja

• Mar 29th, 2006

 

Use dbms_utility.compile_schema procedure to compile all the functions,procedure and packages for a schema.exec dbms_utility.compile_schema('schema_name');

pandish

 Profile Answers by pandish Questions by pandish

• Apr 30th, 2006

 

and use following sql to find the invalid objects.select * from all_objects or dba_objects where status = 'INVALID' ;

Ritesh Singh

• Jul 7th, 2006

 

select object_name,object_type,status from dba_objects

where status='INVALID';

you can run utlrp.sql residing in $ORACLE_HOME/rdbms/admin

and it will try to validate all the objects

GIGI GEORGE

• Oct 3rd, 2006

 

select 'alter '|| DECODE(object_type, 'PACKAGE BODY', 'PACKAGE', object_type)||' '||object_name||' compile;' from user_objects where status<>'VALID' order by object_type try ot this...  then copy and paste on sql prompt..cheersbye

Chiranjeevi Manne

• Mar 30th, 2007

 

The best way to check for the number of invalid objects is using the "UTLRP.SQL" which compiles all the objects source code and lists the number of invalid objects. One after getting the number of invalid objects query v$BH table to get the name of all the invalid objects

samareshp

 Profile Answers by samareshp 

• Apr 20th, 2009

 

select * from all_objects where object_type='PACKAGE' and status= 'INVALID' ;

vaddapalli

 Profile Answers by vaddapalli 

• May 2nd, 2009

 

we can use the  @?/rdbms/admin/utlrp.sql

The below listed are the scripts that were executed to valid the DBMS_STAT on particular databses.

@?/rdbms/admin/dbmsstat.sql

@?/rdbms/admin/prvtstas.plb

@?/rdbms/admin/prvtstat.plb

Sharath

• Jul 27th, 2011

 

you just validate it.. by using validate procedure and validate package commands.. ok don't worry