Hi experts,
We're trying to impdp a dmp file to our database (11.1.0.7 (windows 2008 server)) that was generated from expdp - oracle 11.2 (windows 2008 server) and we're getting the following error:
C:\oracle\admin\appd\dpdump>impdp system/xxx@appd dumpfile=app.DMP logfile=app.log schemas=app
Import: Release 11.1.0.7.0 - 64bit Production on Tuesday, 01 March, 2011 17:03:28
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "C:\oracle/admin/appd/dpdump/app.DMP"
The compatibility of our database is set to 11.1.0.0.0 and the compatibility of the source database is set to 11.2.0.0.0 .
We tried the impdp with the VERSION parameter set to 11.1.0 but it didn't work:
C:\oracle\admin\appd\dpdump>impdp system/xxx@appd dumpfile=app.DMP logfile=app.log schemas=app version=11.1.0
Import: Release 11.1.0.7.0 - 64bit Production on Tuesday, 01 March, 2011 17:03:28
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "C:\oracle/admin/appd/dpdump/app.DMP"
We also tried setting version=COMPATIBLE, and that didn't work too.
Any idea what we can do please?
Please note that the source and target databases are on completely different hosts and networks.
Thanks