Home » RDBMS Server » Server Administration » Cause of invalid objects (Oracle 10.2.0.4.0,SunOS)
Cause of invalid objects [message #554200] Fri, 11 May 2012 05:27 Go to next message
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
Re: Cause of invalid objects [message #554202 is a reply to message #554200] Fri, 11 May 2012 05:31 Go to previous messageGo to next message
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.
Re: Cause of invalid objects [message #554212 is a reply to message #554202] Fri, 11 May 2012 07:02 Go to previous messageGo to next message
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
Re: Cause of invalid objects [message #554221 is a reply to message #554212] Fri, 11 May 2012 07:50 Go to previous message
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.
Previous Topic: Oracle Export Import Utility Different Versions
Next Topic: Change Parameter value in Oracle 11gR2
Goto Forum:
  


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