oracle 导入导出语句

imp USERID/PSD@SID file='D:1.dmp' full=y statistics=none

exp USERID/PSD@SID file='D:1.dmp' tables=(ABC%,CDE%)    //以ABC 或者 CED开头的表

导出空表结构 

exp USERID/PSD@SID file='D:1.dmp' tables=(ABC%,CDE%)  statistics=none 

原文地址:https://www.cnblogs.com/wdw31210/p/4735644.html