Export or Import - Taking backup to import in downgrade oracle version

Export or Import - Taking backup to import in downgrade oracle version

~ Taking full backup using expdp ( RAC / Non-RAC) in Oracle higer version ( e.g., Oracle 11.2.x.x)
~ Import to: Oracle version above 10.2.x.x. in any platform

About Document:
Some times due to space constraint full database to be imported without unused tables / archive tables to  pre-prod/ UAT / DEV database environment to test some scenarios/ to train users / patch movement.

you can follow the below method:

expdp directory=data_pump dumpfile=oraprod_full.dmp logfile=oraprodfull_exp.log full=y exclude=statistics version=10.2

Note:
1) 'version' attribute can be used to import data in lower version ( e.g., Oracle 11g to Oracle 10g)

-- Find currently export executing jobs
sql> select * from dba_datapump_jobs where state='EXECUTING';

Note: Now dump can be used to import in target Oracle version which was mentioned while exporting. i.e., Target database version should be 10.2.x.x.

Click here to see more about expdp and impdp

Please feel free to post comments....
Thanks