GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Scenarios

 Print  |  
Question:  Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.




July 07, 2006 10:38:51 #3
 Ritesh Singh   Member Since: Visitor    Total Comments: N/A 
RE: Very next day on the prodction box It looks some p...
 

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
     

 

Back To Question