[ORACLE] 테이블간 자료이동 insert.. select, create.. select

======================================================================================
create.. select..

CREATE TABLE TABLE1 AS SELECT * FROM TABLE2

======================================================================================
insert.. select..

INSERT INTO TABLE1 SELECT FROM TABLE2 [ WHERE 어쩌구 저쩌구 ]
INSERT INTO TABLE1 ( COL1, COL2, COL3 ) SELECT  COL1, COL2, COL3 FROM TABLE2 [ WHERE 어쩌구 ]

======================================================================================
LONG 타입 데이터 insert.. select.. 하기

create table t1(t1name long);
create table t2(t2name long);
create global temporary table t_long_temp(text_temp clob);
insert into t_long_temp select to_lob(t1name) from t1;
insert into t2(t2name) select  text_temp from t_long_temp;