Range partitioned table with LOB example

create table t1

(

  a  number not null,

  b  date   not null,

  c  clob

) tablespace mytbs

  lob(c) store as lob_c (tablespace mytbs)

  partition by range (b)

  (

   partition b1 values less than (to_date('2010-01-01', 'YYYY-MM-DD')) tablespace mytbs

     lob(c) store as  lob_c1 (tablespace mytbs),

   partition b2 values less than (to_date('2011-01-01', 'YYYY-MM-DD')) tablespace mytbs

     lob(c) store as  lob_c2 (tablespace mytbs),

   partition b3 values less than (to_date('2012-01-01', 'YYYY-MM-DD')) tablespace mytbs

     lob(c) store as  lob_c3 (tablespace mytbs),

   partition b4 values less than (to_date('2013-01-01', 'YYYY-MM-DD')) tablespace mytbs

     lob(c) store as  lob_c4 (tablespace mytbs)

  )

;

create index t1_i1 on t1(a) local

(

  partition i1_1 tablespace mytbs,

  partition i1_2 tablespace mytbs,

  partition i1_3 tablespace mytbs,

  partition i1_4 tablespace mytbs

);