rebuilding text index

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 8 May 2013 17:11:41 -0500
Message-ID: <CAJvnOJY+Lk59qb7ER7Cqd-Ve1LuC6xgMKYTqKER1Yc68te6-_Q_at_mail.gmail.com>



I dont do much with Con Text indexes, so I am probably missing something simple, but I am trying to move a context index to a different tablespace. I found one sample, but it is erroring out. Can someone get me an example of the correct way to do this:
11gR2 on AIX

begin

ctx_ddl.create_preference('MYSTORE', 'BASIC_STORAGE');
ctx_ddl.set_attribute('MYSTORE','I_TABLE_CLAUSE','tablespace newtbsp');
ctx_ddl.set_attribute('MYSTORE','K_TABLE_CLAUSE','tablespace newtbsp');
ctx_ddl.set_attribute('MYSTORE','R_TABLE_CLAUSE','tablespace newtbsp');
ctx_ddl.set_attribute('MYSTORE','N_TABLE_CLAUSE','tablespace newtbsp');
ctx_ddl.set_attribute('MYSTORE','I_INDEX_CLAUSE','tablespace newtbsp');
ctx_ddl.set_attribute('MYSTORE','P_TABLE_CLAUSE','tablespace newtbsp');
end;
/

ALTER INDEX me.index1 rebuild parameters('STORAGE MYSTORE');

ERROR at line 1:

ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX index1 failed
DRG-11000: invalid keyword STORAGE


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 09 2013 - 00:11:41 CEST

Original text of this message