System Packages are invalid
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: System Packages are invalid

  1. #1
    Join Date
    Mar 2000
    Posts
    39

    System Packages are invalid

    Hi there, I ran a query against dba_objects and found 1 system package invalid. I ran alter package compile package. After that I found 2 packages in dba_objects that were invalid. I ran the same alter package against those and now I have over 100 packages showing up as invalid? What do I do????? Thanks in advance.
    Thanks,
    Afshin.

  2. #2
    Join Date
    Mar 2000
    Posts
    39
    The following object types are now invalid:

    OBJECT_TYPE COUNT(1)
    ------------------ ----------
    PACKAGE 23
    PACKAGE BODY 132
    PROCEDURE 3
    VIEW 1
    Thanks,
    Afshin.

  3. #3
    Join Date
    Jun 2000
    Posts
    295
    @?/rdbms/admin/catproc

    to see whether fix your problem.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I've found catproc will cause invalid's, try
    @?/rdbms/admin/utlrp
    to sort this.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  5. #5
    Join Date
    Jun 2002
    Posts
    10
    Did run @?/rdbms/admin/utlrp resolve it?
    Check Note 113947.1 on metalink.oracle.com

  6. #6
    Join Date
    Mar 2000
    Posts
    39
    Sorry for the delay in my response!

    I did run the utlrp.sql command. First time, it fixed some of the objects, but 20 were still invalid. I ran it a second time and now 0 are invalid. Thank you everyone for your help!
    Thanks,
    Afshin.

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