Oracle数据泵操作

数据泵导入

impdp xxx/password@orcl DUMPFILE=xxx.DMP TABLESPACES=xxxSpace remap_schema=xxxUser:aaaUser remap_tablespace=xxxSpace:aaaSpace table_exists_action=replace

数据泵导出

expdp xxx/password directory=DUMP_DIR DUMPFILE=xxx.dmp schemas=xxxUser;

You May Also Like