Oracle 数据库 expdp 和 impdp用法

--查看directory库对象
select * from dba_directories;
/*
SYS  DUMP_TEST  E:\dump
SYS  QUEST_SOO_UDUMP_DIR  /home/oracle/app/oracle/diag/rdbms/bpm/bpm/trace/
SYS  QUEST_SOO_CDUMP_DIR  /home/oracle/app/oracle/diag/rdbms/bpm/bpm/cdump/
SYS  QUEST_SOO_BDUMP_DIR  /home/oracle/app/oracle/diag/rdbms/bpm/bpm/trace/
SYS  QUEST_SOO_ADUMP_DIR  /home/oracle/app/oracle/admin/bpm/adump/
SYS  XMLDIR  /ade/b/2125410156/oracle/rdbms/xml
SYS  DIR_LIKM  E:\dir_likm
SYS  DATA_PUMP_DIR  /home/oracle/app/oracle/admin/bpm/dpdump/
SYS  ORACLE_OCM_CONFIG_DIR  /home/oracle/app/oracle/product/11.2.0/dbhome_1/ccr/state
*/

--给用户赋予导入、导出权限
grant read,write on directory DATA_PUMP_DIR to bpm3_in;

--导出命令
expdp bpm3_in/bpm@bpm schemas=bpm3q_testin dumpfile=bpm3q_testin.dmp DIRECTORY=DATA_PUMP_DIR  
expdp bpm3_in/bpm@bpm schemas=bpm3q_testout dumpfile=bpm3q_testout.dmp DIRECTORY=DATA_PUMP_DIR


--导入命令
--同用户名导入
impdp impdp/bpm DIRECTORY=DATA_PUMP_DIR DUMPFILE=bpm_2round_in.dmp SCHEMAS=bpm_2round_in
impdp impdp/bpm DIRECTORY=DATA_PUMP_DIR DUMPFILE=bpm_2round_out.dmp SCHEMAS=bpm_2round_out

--不同用户名导入
impdp bpm3_in/bpm@bpm DIRECTORY=DATA_PUMP_DIR DUMPFILE=bpm3q_testin.dmp remap_schema=bpm3q_testin:bpm_yanshi_in
impdp bpm3_in/bpm@bpm DIRECTORY=DATA_PUMP_DIR DUMPFILE=bpm3q_testout.dmp remap_schema=bpm3q_testout:bpm_yanshi_out