数据泵迁移之数据落地迁移

登陆数据库
sqlplus / as sysdba

创建导出数据dump用户
create user dump identified by dump;
grant dba to dump;

创建备份目录并赋予权限
mkdir /backup
create directory dump as ‘/backup’;

grant read,write on directory dump to dump;

并行导出数据库到本地
nohup expdp dump/dump directory=dump dumpfile=full_%U.dmp logfile=full.log full=yes parallel=4 &

eg：

nohup impdp dump/dump directory=dump dumpfile=full_01.dmp,full_02.dmp,full_03.dmp,full_04.dmp logfile=full1.log full=yes parallel=4 &

导入数据库
nohup impdp dump/dump directory=dump dumpfile=1,2,3,4 logfile=full1.log full=yes parallel=4 &

单独导出某个用户的表
nohup expdp dump/dump directory=dump dumpfile=full_%U.dmp logfile=full.log schemas=xxx parallel=4 &