数据泵跨版本导入导出用户

低版本到高版本

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