Friday, August 10, 2012

DataPump - expdp, impdp VERSION parameter

To move data between Oracle versions, from a higher version to a smaller one, with DataPump, there is the VERSION parameter, which should be set at export time and import time at destination database level

For example to import in 10.1.0.4 database export from 10.2.0.4:

Run export:

expdp danco directory=WORK_DIR schemas=test dumpfile=test.dmp logfile=test.log version=10.1.0.4.0

Copy dump file from source server to destination server.
Run Import:

impdp danco directory=WORK_DIR dumpfile=test.dmp logfile=test_imp.dmp version=10.1.0.4.0

No comments:

Post a Comment