【转发】怎么着在Oracle中复制表结商谈表数据

  1. 复制表构造及其数量:复制代码
    代码如下:create table table_name_new as select * from
    table_name_old2. 只复制表布局:复制代码
    代码如下:create table table_name_new as select * from
    table_name_old where 1=2;或许:复制代码
    代码如下:create table table_name_new like table_name_old3.
    只复制表数据:
  1. 复制表布局及其数量:

大器晚成经七个表布局相近:复制代码
代码如下:insert into table_name_new select * from
table_name_old要是七个表构造非常小器晚成致:复制代码 代码如下:insert into
table_name_new(column1,column2…) select column1,column2… from
table_name_old

create table table_name_new as select * from table_name_old

  1. 只复制表构造:

create table table_name_new as select * from table_name_old where
1=2;

或者:

create table table_name_new like table_name_old