低版本到高版本
12c导出用户
conn scott/tiger
select default_tablespace from user_users;
expdp system/oracle directory=dump_dir dumpfile=dumpscott.dmp schemas=scott logfile=dumpscott.log
19c导入用户
impdp system/oracle@source directory=dump_dir dumpfile=dumpscott.dmp logfile=impscott.log
高版本到低版本
11g导入用户
ORA-39142: incompatible version number 4.1 in dump file "/home/oracle/backup/dumpscott.dmp"
12c导出用户
导出时标记低版本version
expdp system/oracle directory=dump_dir dumpfile=expscott.dmp schemas=scott logfile=expscott.log version=11.2.0.4
expdp system/密码@IP/bpxtest directory=dump_dir dumpfile=bpxtest_%U.dmp logfile=bpxtest.log full=y cluster=n parallel=8 exclude=STATISTICS version=11.2.0.4.0
11g导入用户
RAC环境下cluster默认为Y
impdp system/oracle@xiqu directory=dump_dir dumpfile=expscott.dmp logfile=impscott.log cluster=N parallel=1