expdp/impdp导出导入数据

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;