oracle小技巧：导出dump文件到指定路径

来源参考：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
)