查看建立的目录
Select * from dba_directories
删除文件
DROP DIRECTORY EXPNC_DIR;
赋权
Grant read,write on directory wly_dump to wly;
导出案例1,按表导出
expdp wly/wly directory=wly_dump dumpfile=wly.dmp logfile=scott.log tables=dept,emp
导出案例2,按用户导出
expdp wly/wly directory=wly_dump dumpfile=wly.dmp schemas=wly
导出案例3,全库导出,且并行导出
expdp wly/wly directory=wly_dump dumpfile=full.dmp parallel=4 full=y
导入案例1,按表导入,从wly到wly2
impdp wly/wly directory=wly_dump dumpfile=tab.dmp tables=scott.dept,scott.emp remap_schema=wly:wly2
导入案例2,按用户导入,从wly到wly2
impdp wly/wly directory=wly_dump dumpfile=schema.dmp remap_schema=wly:wly2
导入案例3,全库导入
impdp wly/wlydirectory=wly_dump dumpfile=full.dmp full=y
导入案例4,无落地文件的用户拷贝,需要建立db link
impdp wly/wly directory=wly_dump network_link=remote_link remap_schema=wly:wly2
其他系统导入导出:
expdp pms/pms@localhost:1521/helowin dumpfile=pms.dmp
full=y directory=DATA_PUMP_DIR
mpdp system/oracle@orcl directory=dump_dir dumpfile=ocap_dev.dmpd remap_tablespace=ocap_dev:ocap_dev remap_schema=ocap_dev:ocap_dev table_exists_action=replace logfile=cbondprices.log