exp/imp parfile 用到的参数
1.exp/imp 对某用户操作(cmp_ras为例)
$cat exp_ccit01_ccit1_cmp_ras.txtuserid=cmp_ras/cmp_ras@ccit01
buffer=999999
grants=y
compress=n
indexes=y
constraints=y
rows=y
file=/oracle/backup/ccit01/exp_imp/exp_ccit01_ccit1_cmp_ras.dmp
log=/oracle/backup/ccit01/exp_imp/exp_ccit01_ccit1_cmp_ras.log
feedback=1000
owner=cmp_ras
$cat imp_ccit01_ccit1_cmp_ras.txt
userid=cmp_ras/cmp_ras@ccit1
buffer=999999
file=/oracle/backup/ccit01/exp_imp/exp_ccit01_ccit1_cmp_ras.dmp
log=/oracle/backup/ccit01/exp_imp/imp_ccit01_ccit1_cmp_ras.log
feedback=1000
fromuser=cmp_ras
touser=cmp_ras
2.exp/imp 某用户下的某些表(drugusr为例)
$cat exp_citic2_ccit01_drugusr_taskproperties.txtuserid=system/cm8ucw3gxy@CITIC_20_170
buffer=999999
compress=n
file=/oracle/database/exp_imp/exp_citic2_ccit01_drugusr_taskproperties.dmp
log=/oracle/database/exp_imp/exp_citic2_ccit01_drugusr_taskproperties.log
feedback=1000000
tables=drugusr.cod_taskproperties
fromuser=drugusr
$cat imp_citic2_ccit01_drugusr_taskproperties.txt
userid=system/system00ccit01@ccit01
buffer=999999
file=/oracle/database/exp_imp/exp_citic2_ccit01_drugusr_taskproperties.dmp
log=/oracle/database/exp_imp/imp_citic2_ccit01_drugusr_taskproperties.log
feedback=1000000
tables=cod_taskproperties
fromuser=drugusr
touser=drugusr
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11780477/viewspace-705049/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11780477/viewspace-705049/