Results 1 to 2 of 2

Thread: invalid package

  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Unanswered: invalid package

    Hey Gang, I created a test database on my machine that had some invalid packages on it. After confirming that sysdba own them and running the necessary scripts to re-compile. I get 3 packages that are still invalid. Is this because the other database reside on servers and this test database reside on my machine.
    Schema
    Package Body
    Created
    Last Modified
    Status

    WKSYS
    WK_CRW
    04-Sep-2001
    09-Sep-2003
    Invalid

    RMAN
    DBMS_RCVCAT
    04-Sep-2001
    03-Sep-2003
    Invalid

    RMAN
    DBMS_RCVMAN
    04-Sep-2001
    03-Sep-2003
    Invalid


    These are the packages that are invalid. What affect will this have on Recovery?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Have you looked at what the errors are?

    sql> select text from all_errors where name = 'DBMS_RCVMAN'

    or

    sql> alter package DBMS_RCVMAN compile body
    sql> sho errors

    Gregg

Posting Permissions

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