Home » RDBMS Server » Server Administration » Invalid Objects
Invalid Objects [message #194894] Tue, 26 September 2006 00:58 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Sometime i faced the error
ORA-20003 - The object that you specified is invalid and cannot be described.
How can we determine which objects become invalid
Do anybody have a script to determine all invalid objects (including procedures,functions,packages,views,synonyms)
can we recomplile all of these objects in a single run?
thanx in advance
Re: Invalid Objects [message #194906 is a reply to message #194894] Tue, 26 September 2006 02:08 Go to previous message
Messages: 52
Registered: August 2006
select * from dba_objects where status = 'INVALID'
Previous Topic: Rebuilding indexes and moving tables to different tablespaces
Next Topic: Problems in compiling invalid objects
Goto Forum:

Current Time: Mon Jul 24 05:59:26 CDT 2017

Total time taken to generate the page: 0.26970 seconds