[HELP] IMP-00017: following statement failed with ORACLE error 4068:
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: [HELP] IMP-00017: following statement failed with ORACLE error 4068:

  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Question [HELP] IMP-00017: following statement failed with ORACLE error 4068:

    Running Oracle 8.1.7 on Windows 2000 x86 Server
    and trying to import a schema dump I get the following error:

    What could be the problem?


    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.07 via conventional path

    Warning: the objects were exported by SYSTEM, not by you

    import done in WE8ISO8859P1 character set and WE8ISO8859P1 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

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Which schema are you importing?
    Are you using a package to do this?
    Do you have a copy of the parfile?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Dec 2002
    Posts
    3
    Originally posted by Mr.Hanky
    Which schema are you importing?
    Are you using a package to do this?
    Do you have a copy of the parfile?

    MH
    Just simply doing from a command prompt:

    imp username/password@instance file=%path fromuser=exportuser touser=schemauser commit=y log=filename.log

    thanks

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Try it again with ignore=y, is that an option?

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Dec 2002
    Posts
    3
    Originally posted by Mr.Hanky
    Try it again with ignore=y, is that an option?

    MH
    Thanks, but adding ignore=y to the imp statement gets the same output as above.

  6. #6
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Can you check if you have any invalid SYS objects. Looks like your SYS.DBMS_REPCAT_UTL objects is INVALID. If yes, then you may need to recreate them logged in with SYSDBA privleges.
    -- Dilip

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