OraFAQ Forum: Server Administration » Cause of invalid objects

Home » RDBMS Server » Server Administration » Cause of invalid objects (Oracle 10.2.0.4.0,SunOS)

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

Cause of invalid objects [message #554200]

Fri, 11 May 2012 05:27

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I have a doubt on invalid objects.

What would be the impact to database and application if there are many invalid objects in database?

Thank you

Report message to a moderator

Re: Cause of invalid objects [message #554202 is a reply to message #554200]

Fri, 11 May 2012 05:31

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

Depends on why they're invalid and whether you are using package global variables (ones declared outside of any procudures/functions)
If objects can all recompile and you aren't using globals - no problem
If objects can all recompile and you are using globals - your probably going to get ORA-04068 errors
If objects can't all recompile you're going to get lots of errors.

Report message to a moderator

Re: Cause of invalid objects [message #554212 is a reply to message #554202]

Fri, 11 May 2012 07:02

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Cookiemaster,

Thank you for the answers.

Quote:

If objects can all recompile and you aren't using globals - no problem
If objects can all recompile and you are using globals - your probably going to get ORA-04068 errors
If objects can't all recompile you're going to get lots of errors.

How to know that i am using globals and can you brief what it is ?

Thank you

Report message to a moderator

Re: Cause of invalid objects [message #554221 is a reply to message #554212]

Fri, 11 May 2012 07:50

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

A variable in a package that isn't declared inside a function or procedure within the package.
So either it is declared in the package spec, or at the top of the package body before the first procedure/function.

Report message to a moderator

Previous Topic:	Oracle Export Import Utility Different Versions
Next Topic:	Change Parameter value in Oracle 11gR2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 11 04:59:35 CDT 2021