[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

Which schema are you importing?
Are you using a package to do this?
Do you have a copy of the parfile?

MH

Quote:

---

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

Try it again with ignore=y, is that an option?

MH

Quote:

---

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.

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.