• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 783
  • Last Modified:

Oracle import problem

Hi,
I am trying to import a .dmp file generated on a 64-bit machine (Release 10.2.0.3.0 - 64bit) onto a 32-bit machine (Release 10.2.0.3.0 - 32bit), but I am getting an error as below:
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

In attach I send you the my dmp and log files!

Have you any idea?

dmp-log.zip
0
ralph_rea
Asked:
ralph_rea
1 Solution
 
k_murli_krishnaCommented:
As per my knowledge 32 bit can be loaded into 64 bit and vice versa not possible.

Excellent article, a must see:

How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers
http://javeedkaleem.blogspot.com/2010/01/how-to-use-export-and-import-when.html

Also, please refer to these:

exp / imp 64 bit <-> 32 bit : Import of .dmp file from 64-bit to 32-bit machine
Indicate dump file is corrupt
http://cn.forums.oracle.com/forums/thread.jspa?messageID=9285303
http://searchoracle.techtarget.com/answer/Import-of-dmp-file-from-64-bit-to-32-bit-machine

Here is a CHECKLIST link which lays out 3 different reasons for this issue
http://abcdba.com/abcdbabackupexpimp3264
0
 
OP_ZaharinCommented:
hi ralph,

- it is possible:
a. export using the  64-bit 10.2.0.3 import utility on source database.
b. import using the 64-bit 10.2.0.3 import utility on source database (or a client PC with 64bit OS and Oracle client installed with connection to the target database). specify the import destination to your 32-bit 10.2.0.3 target database.  

- if you have Oracle Support (Metalink) account, read further in Doc ID 277650.1 - How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers.
0
 
ralph_reaAuthor Commented:
It seems that there are problems if the file is an ASCII file

How Can I check that any transfers of export file are performed in binary mode??
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
OP_ZaharinCommented:
- all oracle export files are in Oracle binary-format. have you try my suggestion in ID: 35423036?
0
 
OP_ZaharinCommented:
- if you are doing a transfer of the export file to other machine, you must make sure that you transfer the file in BINARY mode. if you are using any FTP programs, make sure to specify the mode to BINARY.

- but again, if you trying my steps above, there is no need to move the files elsewhere unless you have other 64bit client machine to work with. just make sure that the 64bit server have connection established to the 32 bit database server.
0
 
ralph_reaAuthor Commented:
I haven't Oracle Support (Metalink) account
OK - all oracle export files are in Oracle binary-format But if FTP Transfer Mode is in ASCII mode?

www.gelosoft.com/FTP_File_Transfer_Modes.doc

0
 
OP_ZaharinCommented:
ralph,
- i believe you can set the preference to move a file extension .dmp as binary. try to find it in your ftp program.

- can i ask, do you want to move the backup file from the 64bit machine to the 32bit machine? the import will not work that way.
0
 
slightwv (䄆 Netminder) Commented:
At the ftp prompt set it to binary mode with the: binary command.

ftp> binary
0
 
OP_ZaharinCommented:
- to further explain on the imp-exp. you need to use the 'exp on the 64bit machine' to export to a dmp file and using the 'imp on the 64bit machine' to import to the 32bit database.
- the syntax for the import would look like this: imp user/password@target32bitdb
- in tnsnames.ora on the 64bit machine, you need to define databases addresses for establishing connections to the 32bit database.
0
 
ralph_reaAuthor Commented:
Dear experts,
I haven't a 64 bit machine.
The DBA that sent me the file told me that the file is a datapump export
I tried this import:
impdp system/password@SID dumpfile=C:\20110413.dmp full=y

But I get this error
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification

The DBA told me these link:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm

Have someone any idea??
0
 
OP_ZaharinCommented:
- you need to specify the DIRECTORY= in that syntax
- the DUMPFILE= cannot contain drive and folder. it should only contain the filename.
0
 
ralph_reaAuthor Commented:
Import terminated successfully
below the correct script:

create or replace directory my_dir as 'C:\my_dir';
grant read,write on DIRECTORY my_dir to public;
impdp system/pwd@MYDB DIRECTORY=my_dir dumpfile=20110413.dmp full=y
0
 
OP_ZaharinCommented:
great! congratulation ralph :)
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now