oracle复制表数据

（1）create table ... AS select:复制表结构和数据

      创建表1：   create table PEOPLE1(Name varchar2(20),Age number(2));

                          insert into PEOPLE1 VALUES('XIAOHUA',12);

                          insert into PEOPLE1 VALUES('XIAODONG',13);

                          insert into PEOPLE1 VALUES('XIAOBEI',14);

      创建表2：create table PEOPLE2 AS select * from PEOPLE1;

                       查询PEOPLE2结构及数据：

                       DESC PEOPEL2;

                       ----------------------------------------------------------------------------

                              名称             |         是否为空       |         类型

                       ----------------------------------------------------------------------------

                             NAME           |                               | VARCHAR2(20)

                      ----------------------------------------------------------------------------

                              AGE             |                               | NUMBER(2)

                      ----------------------------------------------------------------------------

                     select * from PEOPLE2 ;

                      ------------------------------------------------

                             NAME           |         AGE            

                       -----------------------------------------------

                             XIAOHUA     |           12                  

                      ------------------------------------------------

                             XIAODONG  |           13                

                      -------------------------------------------------

                             XIAOBEI       |           14

                      -----------------------------------------------      

         

 (2) insert into ... select :只复制数据

       create table PEOPLE3(Name varchar2(20),Age number(2)) ;

       insert into PEOPLE3 select * from PEOPLE1;

       select * from PEOPLE3;

                       ------------------------------------------------

                             NAME           |         AGE           

                       -----------------------------------------------

                             XIAOHUA     |           12                  

                      ------------------------------------------------

                             XIAODONG  |           13               

                      ------------------------------------------------

                             XIAOBEI       |           14

                      ------------------------------------------------