首页 > 代码库 > dump数据泵导入导出(并发)

dump数据泵导入导出(并发)

简单的导入导出语句:

parafile=paramter.dat    2G表空间=1.2Gdmp
sxg用户为例  dumpdir=d:\backup\dmp


sql>create dircetory dumpdir as ‘d:\backup\dmp‘;
sql>grant read,write on directory dump_dir to sxg;


并行导出数据:
BIN>expdp sxg/sxg@orcl directory=dumpdir  dumpfile=sxg_20140101_%U.dmp log=d:\backup\dmp\sxg.expddlog filesize=6G parallel=10


并行导入数据:
BIN>impdp sxg/sxg@orcl directory=dumpdir dumpfile=sxg_20140101_%U.dmp

parallel=10 log=d:\backup\dmp\sxgimpdp.log


用户或表空间改变
remap_shema=(A:B)
remap_tablespace=(ts_A:ts_B)



dump数据泵导入导出(并发)