exp/imp parfile 用到的参数

1.exp/imp 对某用户操作(cmp_ras为例)

$cat exp_ccit01_ccit1_cmp_ras.txt
userid=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.txt
userid=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/