Question on Interval Partitioning and LOB's
CREATE TABLE AGL_MSG
(
MSG_ID NUMBER(12),
MSG BLOB,
MSG_TMST TIMESTAMP
)
PARTITION BY RANGE(MSG_TMST)
INTERVAL (NUMTOYMINTERVAL(1,'month')) STORE IN (AGLTS300,AGLTS301,AGLTS302,AGLTS303,
AGLTS304,AGLTS305,AGLTS306,AGLTS307,
AGLTS308,AGLTS309,AGLTS310,AGLTS311,AGLTS312)
(
partition p1 values less than (to_date('01/01/2009','mm/dd/yyyy')) TABLESPACE AGLTS301
LOB(MSG) STORE AS (TABLESPACE AGLLS301 DISABLE STORAGE IN ROW),
partition p2 values less than (to_date('02/01/2009','mm/dd/yyyy')) TABLESPACE AGLTS302