比如:
CREATE TABLE T_JOB
( "JOB_ID" NUMBER(*,0) NOT NULL ENABLE,
"IMAGE" BLOB,
"JOB_COMMIT_TIME" DATE NOT NULL ENABLE
) LOB ("IMAGE") STORE AS BASICFILE (
TABLESPACE "TS_IMAGE_BLOB1"
)
PARTITION BY RANGE ("JOB_COMMIT_TIME") INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) STORE IN ("TS_PERSON_DATA1", "TS_PERSON_DATA2")
(PARTITION "TS_PERSON_DATA1" VALUES LESS THAN (TO_DATE(' 1900-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_PERSON_DATA1"
LOB ("IMAGE") STORE AS BASICFILE (
TABLESPACE "TS_IMAGE_BLOB1" DISABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) NOCOMPRESS ) 我怎么写这个建表语句,让lob在TS_IMAGE_BLOB1,TS_IMAGE_BLOB2中循环,非lob在("TS_PERSON_DATA1", "TS_PERSON_DATA2") 循环。
哪位大侠知道呀,赐教一下吧
CREATE TABLE T_JOB
( "JOB_ID" NUMBER(*,0) NOT NULL ENABLE,
"IMAGE" BLOB,
"JOB_COMMIT_TIME" DATE NOT NULL ENABLE
) LOB ("IMAGE") STORE AS BASICFILE (
TABLESPACE "TS_IMAGE_BLOB1"
)
PARTITION BY RANGE ("JOB_COMMIT_TIME") INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) STORE IN ("TS_PERSON_DATA1", "TS_PERSON_DATA2")
(PARTITION "TS_PERSON_DATA1" VALUES LESS THAN (TO_DATE(' 1900-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_PERSON_DATA1"
LOB ("IMAGE") STORE AS BASICFILE (
TABLESPACE "TS_IMAGE_BLOB1" DISABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) NOCOMPRESS ) 我怎么写这个建表语句,让lob在TS_IMAGE_BLOB1,TS_IMAGE_BLOB2中循环,非lob在("TS_PERSON_DATA1", "TS_PERSON_DATA2") 循环。
哪位大侠知道呀,赐教一下吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货