Oracle的exp/imp命令

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