http://www.dba-oracle.com/t_rman_173_impdp_remap.htm
https://oracle-base.com/articles/11g/data-pump-enhancements-11gr1
https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm
https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm

Export

-- 默認(rèn)是SCHEMA模式，導(dǎo)出hr下的所有內(nèi)容
-- DATA_PUMP_DIR是默認(rèn)的導(dǎo)出目錄
expdp hr/password DUMPFILE=DATA_PUMP_DIR:hr_20160229.dmp LOGFILE=DATA_PUMP_DIR:hr_20160229.log

Import

-- DIRECTORY, 使用IMPDP目錄
-- REMAP_SCHEMA, schema映射，從prd_user到dev_user
-- REMAP_TABLESPACE, 表空間映射，從PRDDATA到USERS
-- TABLE_EXISTS_ACTION, 如果表已存在則REPLACE
impdp scott_dev DIRECTORY=IMPDP DUMPFILE=hr_20160229.dmp REMAP_SCHEMA=prd_user:dev_user REMAP_TABLESPACE=PRDDATA:USERS TABLE_EXISTS_ACTION=REPLACE LOGFILE=IMPDP:import_hr_20160229.log

-- TABLES，只導(dǎo)入SYS_SETTING表
impdp scott_dev TABLES=SYS_SETTING DIRECTORY=IMPDP DUMPFILE=hr_20160229.dmp TABLE_EXISTS_ACTION=REPLACE LOGFILE=IMPDP:SYS_SETTING.log

查看目錄：

-- 查看目錄
SELECT * FROM dba_directories;

-- 創(chuàng)建目錄，并賦權(quán)限
CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
GRANT READ, WRITE ON DIRECTORY test_dir TO scott;