expdp和impdp使用示例

创建目录

create or replace directory dumpdir as '/home/oracle/dumpdir';

 

导出：

expdp system/manager@test directory=dumpdir dumpfile=ofbiz.dump schemas=ofbiz logfile=ofbiz_dump.log

 

导入：

impdp system/manager@test directory=dumpdir dumpfile=ofbiz.dump schemas=ofbiz logfile=ofbiz_dump.log

跨用户导入数据：

impdp system/manager@test directory=dumpdir dumpfile=ofbiz.dump remap_schema=ofbiz_old:ofbiz logfile=ofbiz_dump.log