Solved

import failing in oracle 11g r2

Posted on 2014-11-20
6
956 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 76

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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 350 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 34

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 150 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Space Delimited Sql File 4 70
Number Format 1 45
oracle query help 18 78
Oracle Database Upgrade 13 42
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now