oracle导出导入指定表DMP

imp LY_IS2018/LY_IS2018@192.168.36.101:1521/orcl file=E:\ly_is_2018-10-09.dmp log=E:\ly_is_2018-10-09-imp.log ignore=y tables=(LY_XXBZ_BBXX,LY_XXBZ_ZZJGXX,LY_XXBZ_DMJ,LY_XXBZ_DMX,LY_XXBZ_SJKJ,LY_XXBZ_SJDY,LY_XXBZ_SJZD,LY_XXBZ_JGBB,LY_XXBZ_BBZZJG,LY_XTJM_YWB,LY_YWXT_DMJSJ,LY_XXBZ_YWZD)

 

 

exp LY_IS2018/LY_IS2018@192.168.36.101:1521/orcl file=E:\ly_is_2018-10-09-syjpt.dmp log=E:\ly_is_2018-10-09-syjpt.log tables=(LY_XXBZ_BBXX,LY_XXBZ_ZZJGXX,LY_XXBZ_DMJ,LY_XXBZ_DMX,LY_XXBZ_SJKJ,LY_XXBZ_SJDY,LY_XXBZ_SJZD,LY_XXBZ_JGBB,LY_XXBZ_BBZZJG,LY_XTJM_SJY,LY_XTJM_YWB,LY_XTJM_YWBFL,LY_YWXT_DMJSJ,LY_XXBZ_YWZD)

 


版权声明:本文为nqmysbd原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。