天天看點

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