怎么查询oracle的账号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_doracle账号efine,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

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。