techinfo.lib_nation_com.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table LIB_NATION_COM;
CREATE TABLE "TECHINFO"."LIB_NATION_COM" ("IDX_CODE" VARCHAR2(20 
    byte), "FILE_NAME" VARCHAR2(30 byte), "TITLE_CN" VARCHAR2(255
    byte), "TITLE_EN" VARCHAR2(255 byte), "AUTHOR" VARCHAR2(255 
    byte), "AUTHOR_UNIT" VARCHAR2(255 byte), "INTRODUCE_CN" CLOB,
    "INTRODUCE_EN" CLOB, "KEYWORD_CN" VARCHAR2(255 byte), 
    "KEYWORD_EN" VARCHAR2(255 byte), "PAGE_COUNT" NUMBER(5), 
    "GT_SORT" VARCHAR2(30 byte), "GCH" VARCHAR2(50 byte), 
    "O_FILE_NAME" VARCHAR2(50 byte), "REGISTER" VARCHAR2(4 byte),
    "UPDATE_DATE" DATE, "UPDATE_FIELD" VARCHAR2(10 byte), 
    "PUB_YEAR" VARCHAR2(50 byte),id NUMBER PRIMARY   KEY)  
    TABLESPACE "TECHINFO" PCTFREE 10 PCTUSED 0 INITRANS 1 
    MAXTRANS 255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING LOB("INTRODUCE_CN") STORE AS ( TABLESPACE "TECHINFO" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) LOB("INTRODUCE_EN") STORE 
    AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) 
;