[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

import failing in oracle 11g r2

Posted on 2014-11-20
6
Medium Priority
?
2,585 Views
Last Modified: 2014-11-22
dear all,
i have created a dump from oravle 10g,(10.2.0.4) and i am trying to import it into oracle 11g R2(11.2.0.1).
it is giving the following error:
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-02368: the following file is not valid for this load operation
ORA-02369: internal number in header in file O:\TESTDIRECTORY\fullexport20141118
.dmp is not valid
 i am using this command :
impdp system/password@test directory=testdirectory dumpfile=fulle
xport20141118.dmp logFILE=implog.log  full=y.


appreciating your help.
0
Comment
Question by:nayef hamzeh
  • 3
  • 2
6 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40455171
Everything out there on this error seems to point to one of two possibilities:
1: Corrupt DMP file.
2: Moving the DMP file across platforms without proper conversion.

If you can tell us about the FROM OS and the TO OS and how you moved the file, it may help provide additional information.
0
 

Author Comment

by:nayef hamzeh
ID: 40455189
the dump was compressed in rar format.
it was created on windows server 2003 64 bit and i moved it to windows server 2008 r2 64 bit.
honestly i just copy it and paste it.is there other way to move it?
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1400 total points
ID: 40455210
Silly question but I have to ask:
Was the file created with datapump export (expdp) or the classic export(exp)?

If the classic one, you need to use the classic imp.

>>honestly i just copy it and paste it.is there other way to move it?

Windows doesn't have the problem that some moves like using ftp have.

>>it was created on windows server 2003 64 bit and i moved it to windows server 2008 r2 64 bit.

Windows to Windows shouldn't be a problem.

Maybe it was corrupted somehow.  Try compressing and copying it again.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:nayef hamzeh
ID: 40455232
it wad created using expdp
i will try compressing and copying it agian and will feed you back
0
 
LVL 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 600 total points
ID: 40455690
Maybe compressing and uncompressing the file causes the problem.  Try copying it and using it uncompressed.
0
 

Author Closing Comment

by:nayef hamzeh
ID: 40459440
the issue was solved.looks it was corrupted.i decompressed again and it worked fine.thank you all
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question