how to import oracle 11g dump file to 10g oracle

oracle, oracle-dump

Solution

You can import your `Oracle 11g` `expdp dump file` into `Oracle 10g` if you make sure you use `VERSION=10.2` parameter during export. like:

expdp hr/hr TABLES=hr.employees VERSION=10.2 DIRECTORY=data_pump_dir 
DUMPFILE=emp.dmp LOGFILE=emp.log

(Assuming you want to import in `Oracle 10.2`)

and use `impdp` as usual, like:

impdp hr/hr TABLES=hr.employees DIRECTORY=data_pump_dir
DUMPFILE=emp.dmp LOGFILE=emp_imp.log

Problem

when I tried to import oracle database 11g into oracle 10g I got this error. IMP:00010 Not a valid export file. header failed identification IMP:00000 Import terminated unsucessfully any help, please

Original source