after i have exported the data from my source database which is 12cR1 and imported the dump to the destination database which is 11gR2 , i faced the below error:
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 4.1 in dump file “/export/dir/test.dmp”
In order to fix this error, you need to lower the exported dump version using the “version” parameter from the source 12cR1 database, using the command:
nohup $ORACLE_HOME/bin/expdp “‘/as sysdba ‘” DIRECTORY=DIR DUMPFILE=test.dmp TABLES=sch1.test_table version=11.2 logfile=test_exp.log &
remark: nohup will let the expdp command execute on the background.
so the trick is to add the “version” parameter