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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-750478/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26015009/viewspace-750478/