OraFAQ Forum: Server Administration » Compiling INVALID Objects

Home » RDBMS Server » Server Administration » Compiling INVALID Objects

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Compiling INVALID Objects [message #264562]

Mon, 03 September 2007 14:19

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

Report message to a moderator

Re: Compiling INVALID Objects [message #264563 is a reply to message #264562]

Mon, 03 September 2007 14:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

as SYS
SQL>@ORACLE_HOME/rdbms/admin/utlrp.sql

Report message to a moderator

Re: Compiling INVALID Objects [message #264574 is a reply to message #264563]

Mon, 03 September 2007 16:33

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

Report message to a moderator

Re: Compiling INVALID Objects [message #264575 is a reply to message #264562]

Mon, 03 September 2007 16:48

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Compiling INVALID Objects [message #266402 is a reply to message #264562]

Mon, 10 September 2007 14:31

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.

Report message to a moderator

Previous Topic:	Tuning Oracle Analyze
Next Topic:	64 bit oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:33:18 CST 2024