oracle里面复制表数据和表结构比较方便,例如:以user表为例,
1、只复制表结构(创建新表)
create table user_new as select * from user where 1=2
2、复制表数据和结构(创建新表)
create table user_new as select * from user 或者 create table user_new like user
3、复制表数据(两个表结构一致)
insert into user_new select * from user
4、复制表数据(两个表结构不一致)
insert into user_new(column1,column2,......) select column1,column2,...... from user