--复制表结构
create table table_name_new as (select * from table_name_old) definition only;
--插入数据
insert into table_name_new (select * from table_name_old);
也可以用export 、import来插入数据
--复制表结构,但是不复制主键、约束、索引...
create table table_name_new like table_name_old;