expdp导出数据步骤
1、创建目录
create directory dir_expdp as '/syjkccs/dir_expdp';
2、授权
grant read,write on directory dir_expdp to tpl;
3、查看目录及权限
select * from dba_directories;
4、执行导出
expdp tpl/tpl@hnccs_pr schemas=tpl directory=dir_expdp dumpfile=expdp_ccsdb.dmp logfile=expdp_ccsdb.log;
note:目录在os上必须存在,不然会提示ORA-39070: Unable to open the log file
impdp导入数据
目标数据库需存在expdp_ccsdb目录
impdp tpl/tpl@syjk schemas=tpl dumpfile =expdp_ccsdb.dmp logfile=expdp_ccsdb.log directory=dir_expdp;