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
ralph_reaAsked:
Who is Participating?
 
OP_ZaharinConnect With a Mentor Commented:
- you need to specify the DIRECTORY= in that syntax
- the DUMPFILE= cannot contain drive and folder. it should only contain the filename.
0
 
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.