expdp数据泵全库导出和导入

创建路径

create directory expdp as '/u01/expdp'; 
Grant read,write on directory expdp to system;

查看权限

col PRIVILEGE for a10
col DIRECTORY_PATH for a25
SELECT privilege, directory_name, DIRECTORY_PATH 
FROM user_tab_privs t, all_directories d 
WHERE t.table_name(+) = d.directory_name ORDER BY 2, 1;

导出

expdp system/oracle dumpfile=full2013.dmp full=y logfile=full2013.log directory=expdp job_name=my_job

重新建库，在新库上创建目录

create directory expdp as '/u01/expdp'; 
Grant read,write on directory expdp to system;

将dmp文件scp到新机器的新路径中

导入

impdp system/oracle dumpfile=full2013.dmp full=y logfile=full2013.log directory=expdp job_name=my_job