Oracle 表备份还原

方法1:

create table mdmuser20120801 as select * from mdmuser
  方法2: create table mdmuser20120801 as select * from mdmuser where 1=2;
insert into mdmuser20120801 select from mdmuser ;