which BASIC_STORAGE relevant to CTXCAT index ?

From: Yoram Ayalon <yoram.ayalon_at_structuredweb.com>
Date: 21 Jun 2006 12:05:53 -0700
Message-ID: <1150916753.912219.201530@u72g2000cwu.googlegroups.com>

I am trying to build a CTXCAT index, and have it reside on its own tablespace. Oracle examples on storage clauses are very hazy and do not differentiate between CTXCAT, CONTEXT, etc.

which clauses are needed for a CTXCAT index, and how do I incorporate into the CREATE_INDEX comamnd ?

if I understand correctly, I need this:

EXEC ctx_ddl.create_index_set('myindexset'); EXEC ctx_ddl.add_index('myindexset', 'col1'); ...

ctx_ddl.create_preference('mystore', 'BASIC_STORAGE'); ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE', 'tablespace txtTablespace storage (initial 1000M)'); ....

and then
CREATE INDEX myindex_CTX ON mytable(mycolumn) INDEXTYPE IS CTXSYS.CTXCAT
PARAMETERS ('INDEX SET myindexset' ,'STORAGE mystore');

am I on the right track here? again, which clauses do I have to use for the storage? Received on Wed Jun 21 2006 - 14:05:53 CDT