-
[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
I remember when this place was cool.
-
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
I remember when this place was cool.
-
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.
-- 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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|