Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to partition only LOB column but not data/index?
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
![]() |
![]() |