Results 1 to 2 of 2

Thread: Export problem

  1. #1
    Join Date
    Jul 2003
    Posts
    129

    Unanswered: Export problem

    My System : win2k/Oracle9i server ( i have run the catalog.sql )

    i tried to do a full export using
    Code:
    exp 'sys/password as sysdba' full=y consistent=y file=EXPORT.DMP log=EXPORT.LOG
    and here are the error messages

    Code:
    ......
    ......
    . exporting foreign function library names
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions
    . exporting system procedural objects and actions
    EXP-00008: ORACLE error 4068 encountered
    ORA-04068: existing state of packages has been discarded
    ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.system_info_exp
    EXP-00008: ORACLE error 6502 encountered
    ORA-06502: PL/SQL: numeric or value error: NULL index table key value
    ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 130
    ORA-06512: at line 1
    EXP-00085: The previous problem occurred when calling SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp for object 3844
    EXP-00008: ORACLE error 6502 encountered
    ORA-06502: PL/SQL: numeric or value error: NULL index table key value
    ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 130
    ORA-06512: at line 1
    EXP-00085: The previous problem occurred when calling SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp for object 3845
    EXP-00008: ORACLE error 6502 encountered
    What cause the packages corruption?

  2. #2
    Join Date
    Jul 2003
    Posts
    129
    any idea?

Posting Permissions

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