首页 > Linux操作系统 > Linux操作系统 > expdp and impdp
create directory dump_dir as '/home/oracle';
create directory log_dir as '/home/oracle';
expdp test/test schemas=test dumpfile=dump_dir:test%U.dmp logfile=log_dir:test.log
expdp test/test schemas=test dumpfile=dump_dir:testa%U.dmp,dump_dir:testb%U.dmp filesize parallel=2 logfile=log_dir:test.log
expdp parfile=test.par schemas=test dumpfile=dump_dir:mytest.dmp logfile=log_dir:mytest.log
$ cat test.par
USERID=test/test
$
impdp system/xxx schemas=test dumpfile=dump_dir:mytest.dmp logfile=log_dir:mytest.log
impdp test/test schemas=test dumpfile=dump_dir:testa%U.dmp,dump_dir:testb%U.dmp parallel=2 logfile=log_dir:test.log
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/11411056/viewspace-734372/ ,如需转载,请注明出处,否则将追究法律责任。