Database DataWarehousing (MOSC)

MOSC Banner

Question on Interval Partitioning and LOB's

edited Mar 21, 2012 10:37AM in Database DataWarehousing (MOSC) 8 commentsAnswered
During the initial creation of the partition table, I was able to specifically specify which tablespace the LOB will go to as well as 'disable storage in row'

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center