急：oracle中复制表

Question

create table "WXGXPT"."TEST"
 as select * from "YWSQ_TEMP"."ADFFFTT"

Answer 1

SQL> select * from t;      COL1 COL2                 COL3
---------- -------------------- ----------
         1 11                   08-6月 -05
         2 22                   08-6月 -05
         3 33                   08-6月 -05已用时间:  00: 00: 00.40
SQL> create table t2 as select * from t;表已创建。已用时间:  00: 00: 00.21
SQL> select * from t2;      COL1 COL2                 COL3
---------- -------------------- ----------
         1 11                   08-6月 -05
         2 22                   08-6月 -05
         3 33                   08-6月 -05已用时间:  00: 00: 00.20
SQL>