Invalid Objects
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Invalid Objects

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Invalid Objects

    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

  2. #2
    Join Date
    Jul 2005
    Posts
    16

    Wink

    select * from all_objects where status = 'INVALID'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width