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
/
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-lReceived on Thu May 09 2013 - 00:11:41 CEST