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

Thread: Invalid objects

  1. #1
    Join Date
    Oct 2008
    Chandigarh, India

    Invalid objects

    i found certain packages in my database with status invalid. I recompiled them n again checked the number of invalid objects. I found that the number has increased now. I again tried to recompile the objects such as packages but upon further checking, their number(invalid objects) kept on increasing. I m not able to understand the dilemma.
    I used dba_objects data dictionary table.
    Command used are:
    --select object_name,object_type,status from dba_objects
    where status='INVALID';
    --alter object_type object_name compile;

  2. #2
    Join Date
    Sep 2002
    if you compile something which something else is dependant on, then they will go invalid.

    best bet is to just compile the body - not the spec

  3. #3
    Join Date
    Nov 2000
    Pittsburgh, PA
    Try using the $ORACLE_HOME/rdbms/admin/utlrp.sql recompile
    script. If I had to guess you are missing some grants.
    You can also use this query to see what grant/objects you might be missing.

    COLUMN missing_object FORMAT A40

    SELECT owner, name, type,
    referenced_owner||'.'||referenced_name missing_object
    FROM dba_dependencies where (owner, name) in
    ( SELECT owner, object_name
    FROM dba_objects
    WHERE status='INVALID' )
    AND referenced_type = 'NON-EXISTENT'
    ORDER BY 1, 2, 4;

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