techinfo.lib_dldt.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table LIB_DLDT;
CREATE TABLE "TECHINFO"."LIB_DLDT" ("SORT_CODE" VARCHAR2(80 byte),
    "TITLE" VARCHAR2(250 byte), "SOURCE" VARCHAR2(250 byte), 
    "PUB_DATE" DATE, "REG_DATE" DATE, "PUB_YEAR" VARCHAR2(50 
    byte), "PAGE_COUNT" VARCHAR2(50 byte), "CONTENT" CLOB, 
    "IDX_CODE" VARCHAR2(50 byte), "AUTHOR" VARCHAR2(50 byte), 
    "PATH" VARCHAR2(50 byte), "FILE_NAME" 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("CONTENT") STORE AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) 
;