expdp与impdp例子

CREATE OR REPLACE DIRECTORY dir_dump  AS '/u01/RLZY/';



GRANT read,write ON DIRECTORY dir_dump TO public;

C:\Documents and Settings\Administrator>expdp insur_backup/backup@rlzy directory
=dir_dump dumpfile=backupchangde.dmp logfile=backupchangde.log


将insur_backup(cdcs表空间)用户的对象导入insur_test(hygeiatest表空间)
C:\Documents and Settings\Administrator>impdp insur_backup/backup@rlzy directory
=dir_dump dumpfile=backupchangde.dmp remap_schema=insur_backup:insur_test remap_
tablespace=cdcs:hygeiatest logfile=impjy.log parallel=2