batch file
expdp user/pass@ORCL parfile=exp_m.txt
exp_m.txt
DIRECTORY=ORA_EXP
DUMPFILE=exp_m
LOGFILE=exp_m.log
reuse_dumpfiles=YES
TABLES=(hogehome)
batch file
impdp user/pass@ORCL parfile=imp_m.txt
imp_m.txt
directory=ORA_EXP
dumpfile=exp_m.dmp
logfile=impdp_m.log
TABLE_EXISTS_ACTION=REPLACE
TABLES=(hogehoge)
0 件のコメント:
コメントを投稿