임시테이블 생성

CREATE TABLE DASH_TMP
(
   WORKDATE DATE
 , DESCRIPTION VARCHAR2(4000)
 , COL1 VARCHAR2 (100)
 , COL2 VARCHAR2 (100)
 , COL3 VARCHAR2 (100)
 , COL4 VARCHAR2 (100)
 , COL5 VARCHAR2 (100)
 , COL6 VARCHAR2 (100)
 , COL7 VARCHAR2 (100)
 , COL8 VARCHAR2 (100)
 , COL9 VARCHAR2 (100)
 , COL10 VARCHAR2 (100)
 , DAT1 DATE
 , DAT2 DATE
 , DAT3 DATE
 , DAT4 DATE
 , DAT5 DATE
 , DAT6 DATE
 , DAT7 DATE
 , DAT8 DATE
 , DAT9 DATE
 , DAT10 DATE
 , RICHTEXT1 VARCHAR2(4000)
 , RICHTEXT2 VARCHAR2(4000)
 , RICHTEXT3 VARCHAR2(4000)
 , RICHTEXT4 VARCHAR2(4000)
 , RICHTEXT5 VARCHAR2(4000)
 , RICHTEXT6 VARCHAR2(4000)
 , RICHTEXT7 VARCHAR2(4000)
 , RICHTEXT8 VARCHAR2(4000)
 , RICHTEXT9 VARCHAR2(4000)
 , RICHTEXT10 VARCHAR2(4000)
);

 

VARCHAR2(6000) 은 너무 커서 안되었다.