Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

import dumps on a different database version

3529101Oct 18 2017 — edited Oct 20 2017

Hello Folks,

I'm in a critical situation, i have got dumps exported from 12c without specifying the version and now I'm in need of importing it to another database version 11.2.0.4.0.

This is urgently needed by the business and am wondering how it can be done.

this is the command I'm using

nohup impdp bibfeb/a12345678 schemas=BIB remap_schema=BIB:bibfeb REMAP_TABLESPACE=TS_BIB_M_13M_201602:febdata directory=DATA_PUMP_DIR version=11.2.0.4.0  dumpfile=TS_BIB_M_13M_201602_%U.dmp logfile=TS_BIB_M_13M_201602.log parallel=12 CLUSTER=N > febdata.out &

Error message:

[oracle@rwpclfdb02 ~]$ tail -f febdata.out

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-39142: incompatible version number 4.1 in dump file "/restore/bib/TS_BIB_M_13M_201602_01.dmp"

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2017
Added on Oct 18 2017
14 comments
1,179 views