Oracle数据泵的导入导出

su - oracle
sqlplus / as sysdba

SELECT * FROM dba_directories;

CREATE OR REPLACE DIRECTORY data_pump_dir AS '/u01/app/oracle/admin/orcl/dpdump/';
GRANT read,write ON DIRECTORY data_pump_dir  TO public;

exit;
expdp cdr_st/cdr_st@orcl DIRECTORY=DATA_PUMP_DIR DUMPFILE=cdr_st_20161108.dup logfile=cdr_st_20161108.log

impdp cdr_st/cdr_st@orcl  DIRECTORY=DATA_PUMP_DIR DUMPFILE=cdr_st_20161108.dup full=y
--注意：上面的 DATA_PUMP_DIR 为目标数据库的 DIRECTORY 名称，具体还要看目标数据库的实际情况。