数据泵导入导出--oracle

--导入数据（相同用户）--impdp EFMIS_CMS/1@ppporcl DIRECTORY=DATA_PUMP_DIR  DUMPFILE=EXPDAT.dmp LOGFILE=20150508EFMIS_CMS.log  TRANSFORM=OID:N,SEGMENT_ATTRIBUTES:N--导入数据（不同用户）impdp user_ppp/user_ppp@wdbd DIRECTORY=DATA_PUMP_DIR SCHEMAS=EFMIS_CMS REMAP_SCHEMA=EFMIS_CMS:user_ppp remap_tablespace=PPP_DATA:data_ppp DUMPFILE=EXPDAT.DMP  TRANSFORM=OID:N,SEGMENT_ATTRIBUTES:N

--导出数据

expdp EFMIS_CMS/1@192.168.1.102:1521/orcl directory=data_pump_dir dumpfile=PPP_20150716.dmp logfile=PPP_20150716.log exclude=index_statistics,table_statistics compression=all