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