Oracle复制表结构数据

1、复制表结构

create   table_name   as   select   *   from   Source_table   where   1 <> 1;

2、复制表结构及数据

create   table_name   as   select   *   from   Source_table   where   1=1;