data pump總結

expdp匯出

1、建立匯出的目錄

create or replace directory expdp_dir as 'd:\exp';

grant read,write on directory expdp_dir to hrb03;

2、執行匯出命令

expdp hrb03/hrb03 directory=expdp_dir dumpfile=topicis_hrb03.dmp logfile=topicis_hrb03.log

 

impdp匯入

create or replace directory impdp_dir as 'd:\exp';

grant read,write on directory impdp_dir to hrb03;

執行匯入命令

impdp hrb03/hrb03 directory=impdp_dir dumpfile=topicis_hrb03.dmp logfile=topicis_hrb03.log

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28803801/viewspace-774089/，如需轉載，請註明出處，否則將追究法律責任。