How to EXPDP and IMPDP from Higher version to Lower version in oracle database.
In this Blog I have explain how to take export from one database which have the higher version 12c and import it in other database server where we are using lower version 11g. Some time we need this type of scenario in real time environment and we can use the below steps to perform the export and import between two database server. Although if you want to do on same server and want the same schema copy in different name then you can use the below steps only you need to exclude version parameter from export.
Total space allocated by Owner:
set pages 9999 lines 300
col owner format a15
col segment_name format a30
col segment_type format a15
col tablespace_name format a20
col mb format 999,999,999
select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 “SIZE in MB”
from dba_segments
where owner='&username';
select count(*) from dba_objects where owner=’&username’;
Here in export set the target machine database compatible version because if your source is 12c and you want to import this backup on lower version like on 11g then check the version of 11g database
and use it into source 12c database export command.
vi EXPDP_ABC.par
USERID="/ as sysdba"
DIRECTORY=EXP_DIR
DUMPFILE=EXPDP_ABC.dmp
LOGFILE=EXPDP_ABC.log
schemas=ABC
VERSION=11.2.0.4.0
To run in background this jobs use nohup command.
nohup expdp parfile=EXPDP_ABC.par &
jobs -l
after that it will create nohup.out (output file) you can check out
tail -100f nohup.out
and also view the logfile of export EXPDP_ABC.log for more information.
Now transfer the exported dumpfile to target machine where you want to import and
create the parfile for import operation. As per below example we have created the IMPDP_ABC.par file for import operation and mentioned the mandatory parameters which are required.
Note – When we do the import…good practice is import into different tablespace. Same we did in below example in remap_tablespace parameter.
vi IMPDP_ABC.par
USERID="/ as sysdba"
LOGFILE=impdp_ABC.log
DUMPFILE=EXPDP_ABC.dmp
DIRECTORY=DMP_DIR
remap_schema=ABC:NEWTEST
remap_tablespace=USERS:TBS
Need to do import into 11g ….from 12c (source)
nohup impdp parfile=IMPDP_ABC.par &
jobs -l
After that it will create nohup.out (output file) you can check out
tail -100f nohup.out
and also view the logfile of export impdp_ABC.log for more information.
Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.
Please comment here for your any query related to above post. You can email me on : oracleocpworld@gmail.com.