Home » RDBMS Server » Server Administration » Compiling INVALID Objects
Compiling INVALID Objects [message #264562] Mon, 03 September 2007 14:19 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
I queried DBA_OBJECTS and found out that I have 105 INVALID
objects which i think is not good for my database.
Please how do I re-compile these objects and make them VALID?

Thanks and regards,

Cherish
Re: Compiling INVALID Objects [message #264563 is a reply to message #264562] Mon, 03 September 2007 14:21 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
as SYS
SQL>@ORACLE_HOME/rdbms/admin/utlrp.sql
Re: Compiling INVALID Objects [message #264574 is a reply to message #264563] Mon, 03 September 2007 16:33 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Thanks so much.

It worked but I still have some Package & Package Bodies
that are INVALID. In this case what do I do next?

Regards,

Cherish
Re: Compiling INVALID Objects [message #264575 is a reply to message #264562] Mon, 03 September 2007 16:48 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
It depends.
Who owns them, what are the packages & why do they fail to compile?
If nothing ever uses them, then ignore the failure to compile.
Re: Compiling INVALID Objects [message #266402 is a reply to message #264562] Mon, 10 September 2007 14:31 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
try running utlrp.sql a couple of time.... every time, the number of INVALID objects may reduce as there may be some dependencies on the objects.

When the number is low (say 10 objects are invalid, then compile them indivually. If the object DOES NOT compile, then see the error. May be the object cannot compile at all ... meaning that the code is bad.
--
Sanjay B.
Previous Topic: Tuning Oracle Analyze
Next Topic: 64 bit oracle
Goto Forum:
  


Current Time: Sat Dec 10 12:46:34 CST 2016

Total time taken to generate the page: 0.07721 seconds