Oracle中复制表结构和表数据

一、复制表结构及其数据

create table new_table as (select * from old_table);

create table new_table as (select * from old_table where 1=2);

如果两个表结构一样：

insert into new_table select * from old_table;

insert into new_table(column1,column2...) select column1,column2... from old_table;