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

Thread: Invalid Objects

  1. 09-26-2006, 01:51 AM #1
    M.Shakeel Azeem
    M.Shakeel Azeem is offline Member
    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
    Reply With Quote Reply With Quote
  2. 09-26-2006, 02:58 AM #2
    ahmadbilal
    ahmadbilal is offline Junior Member
    Join Date
    Jul 2005
    Posts
    16

    Wink

    select * from all_objects where status = 'INVALID'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width