Results 1 to 2 of 2

Thread: Imp problem

  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: Imp problem

    I'm getting the following errors and can't seem to do anything about it.

    Export file created by EXPORT:V08.00.05 via conventional path
    import done in US7ASCII character set and US7ASCII NCHAR character set
    IMP-00017: following statement failed with ORACLE error 4068:
    "BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
    IMP-00003: ORACLE error 4068 encountered
    ORA-04068: existing state of packages has been discarded
    ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 94
    ORA-06512: at line 1
    IMP-00000: Import terminated unsuccessfully

    I have tried recompiling DBMS_REPCAT_UTL but it's still compiling with errors. I'm running 8i(8.1.7) on redhat 8.0 linux. Please help!

  2. #2
    Join Date
    Mar 2002
    Location
    Brooklyn, NY
    Posts
    5

    IMP-00017 error 4068

    It looks like your running into the same problem as specified in Metalink Note 203317.1 (Import fails with IMP-00017 IMP-00003 ORA-04068).
    The Note gives the solution:
    --------------
    This error may occur due to invalid replication packages
    From svrmgrl,Please connect as internal .

    Run the following scripts that resides under $ORACLE_HOME/rdbms/admin

    1)catrepr.sql (Removes Replication related objects)

    2)catrep.sql (Creates Replication related objects)

    3)utlrp.sql (Recompile Invalid PL/SQL modules).

    After this rerun the import.

Posting Permissions

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