Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to partition only LOB column but not data/index?

How to partition only LOB column but not data/index?

From: Ed Wong <ewong_at_mail.com>
Date: 17 Jul 2001 16:05:29 -0700
Message-ID: <a5ae1554.0107171505.4e036b35@posting.google.com>

I am trying to have a 100GB table partitioned. I want to have the regular column and index on tablespaces user_data and user_index tablespace respectively. With the clob column, I want to create hash partition on tablespaces user_lob_p1, user_lob_p2, user_lob_p3 and user_lob_p4. But I notice that the index goes to the index tablespace, but the table as well as clob goes into the partition tablespaces. I would like to know how to separate table and it's clob. This is what I do -

Create table test
(id number(10),

 name varchar2(10),
 output CLOB,
 constraint pk_test primary key (id) using index tablespace user_index storage (...)
)
tablespace user_data storage (...)
LOB (output) store as lob_test
(storage (...))

partition by HASH(id)
(partition test_lob_p1 tablespace user_lob_p1,

 partition test_lob_p2 tablespace user_lob_p2,
 partition test_lob_p3 tablespace user_lob_p3,
 partition test_lob_p4 tablespace user_lob_p4
);

Thanks. Received on Tue Jul 17 2001 - 18:05:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US