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