Oracle的exp/imp命令
程序员文章站
2022-09-14 16:59:08
1、IMP命令：
imp system/manager@TEST ignore=y full=y file=d:\daochu.dmp log=d:\daoru.txt
2、E...
1、IMP命令：
imp system/manager@TEST ignore=y full=y file=d:\daochu.dmp log=d:\daoru.txt
2、EXP命令：
（1）指定表导出：
exp auto/auto@jxcmc_ng compress=y file=/data01/billapp/users/lulu/20170824/autotest.dmp log=/data01/billapp/users/lulu/20170824/exp.log TABLES=at_tc,at_tc_steps,at_tc_step_para,at_tc_var_val,at_tc_project_def,at_tc_var_def,at_tc_xdr_define,at_tc_func_parameter,at_tc_funcs,at_tc_tmpl_base,at_tc_tmpl_step,at_tc_tmpl_param
（2）全表导出：
exp auto/auto@jxcmc_ng compress=y full=y file=/data01/billapp/users/lulu/20170824/autotest.dmp log=/data01/billapp/users/lulu/20170824/exp.log