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