Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> which BASIC_STORAGE relevant to CTXCAT index ?
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