Can I add two lob column to two hash partitions?

From: Ed Wong <ewong_at_mail.com>
Date: 26 Feb 2002 14:36:17 -0800
Message-ID: <a5ae1554.0202261436.385fce42@posting.google.com>

I have a 100GB table with one blob column initally.

id         integer
name       varchar2(100)
output     blob

The table is hash partition by id into 4 different tablespaces(ts1 - ts4). The individual "output" blob column is also hash partition by id into 4 different tablespaces(ts_output1 - ts_output4). Now, I want to add a "textoutput" clob column and like to have the same hash partition by id so that the clob split into 4 tablespaces(ts_textoutput1 - ts_textoutput4).

My first question is does it make sense?

Second question is I got the following error message:

SQL> alter table outputresult add (textoutput clob) lob(textoutput) store as lob_outputresult_textoutput
( storage (initial 100m next 100m minextents 1
maxextents unlimited pctincrease 0 freelists 1 freelist groups 1) chunk 8k pctversion 20 nocache disable storage in row) partition by hash(id)
(partition outputresult_textoutput_p1 tablespace ts_textoutput1,

 partition outputresult_textoutput_p2 tablespace ts_textoutput2,
 partition outputresult_textoutput_p3 tablespace ts_textoutput3,
 partition outputresult_textoutput_p4 tablespace ts_textoutput4)

/
partition by hash(id)
*
ERROR at line 6:
ORA-01735: invalid ALTER TABLE option

Please help. Thanks in advance. Received on Tue Feb 26 2002 - 16:36:17 CST