来源参考:https://www.iteye.com/blog/mofeichen-2165917
DATA_PUMP_DIR impdp 指定导出目录
1. mkdir /tdms1/oracle/dump
2. sqlplus / as sysdba
3. create directory DATA_PUMP_DIR1 as '/home/db/oracle/dumpfile/temp';
4. grant write ,read on directory DATA_PUMP_DIR1 to scott;
5.exit
6. select * from dba_directories t;
1 SYS ORACLE_OCM_CONFIG_DIR /app/oracle/product/11.2.0/db_1/ccr/state
2 SYS DATA_PUMP_DIR /app/oracle/admin/TDMS/dpdump/
3 SYS DATA_PUMP_DIR1 /home/db/oracle/dumpfile/temp
4 SYS XMLDIR /ade/b/2125410156/oracle/rdbms/xml
7.expdp test/test@TDMS directory=UDIR dumpfile=tdms_20141212pm1700.dmp version=11.2.0.1.0
exp.par内容
USERID="test/test"
DIRECTORY=DATA_PUMP_DIR1
DUMPFILE=1.dmp
LOGFILE=exp_table.log
COMPRESSION=ALL
FILESIZE=4G
EXCLUDE=STATISTICS
tables=(
table1,tables2
)