imp system/manager@cfp00_cpzbzhcx parfile=e:/dbbackup/imp_full_cfp10/imp_full.par
imp_full.par的内容是
filesize=0
buffer=81920
commit=y
ignore=y
fromuser=(cp,cp00,cp01,cp02,cp03,cp04,cp05,cp06,cp07,cp08,cp09,cp10,cp11,cp12,cp13,
cp14,cp15,cp16,cp17,cp19,cp20,cp80,cp51,cp52,cp53,cp54,cp55,cp56,cp50,cpzb)
touser=(cp,cp00,cp01,cp02,cp03,cp04,cp05,cp06,cp07,cp08,cp09,cp10,cp11,cp12,cp13,cp14,
cp15,cp16,cp17,cp19,cp20,cp80,cp51,cp52,cp53,cp54,cp55,cp56,cp50,cpzb)
file=(e:/dbbackup/exp_cpzb01.dmp,e:/dbbackup/exp_cpzb02.dmp,e:/dbbackup/exp_cpzb03.dmp,
e:/dbbackup/exp_cpzb04.dmp,e:/dbbackup/exp_cpzb05.dmp,e:/dbbackup/exp_cpzb06.dmp,
e:/dbbackup/exp_cpzb07.dmp,e:/dbbackup/exp_cpzb08.dmp,e:/dbbackup/exp_cpzb09.dmp,
e:/dbbackup/exp_cpzb10.dmp)
log=e:/dbbackup/imp_full_cfp10/imp_full.log
http://blog.csdn.net/inthirties/archive/2009/07/03/4318323.aspx
导出命令:exp parfile=exp_parfile.par
exp_parfile.par文件内容
userid=system/pass@dbsid
direct=y
compress=n
log=exp_pausersz.log
recordlength=65535
filesize=4096m
file=(
expsz01.dmp,expsz02.dmp,expsz03.dmp,expsz04.dmp,expsz05.dmp,expsz06.dmp,expsz07.dmp,expsz08.dmp,expsz09.dmp,expsz10.dmp
)
owner=(
scott,hr,.....)
