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

Report message to a moderator

Re: Invalid Objects [message #194906 is a reply to message #194894] Tue, 26 September 2006 02:08 Go to previous message
aorehek
Messages: 52
Registered: August 2006
Member
 
select * from dba_objects where status = 'INVALID'

Report message to a moderator

Previous Topic: Rebuilding indexes and moving tables to different tablespaces
Next Topic: Problems in compiling invalid objects
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:34:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.