创建路径
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