This discussion is archived
2 Replies Latest reply: Nov 29, 2012 2:04 AM by 882532 RSS

Oracle Text, multi_column_datastore describe index

882532 Newbie
Currently Being Moderated
Referring to Re: Oracle Text, ctxsys.context problem with number column

In TOAD or SQL Navigator you can click on some object (like table, index) and click on tab "script" where is generated the code to create it.

Assuming that I am a person who sees the index for the first time where/how I can find multi_columns/parameters with which the index was created ?

For example:
exec ctx_ddl.drop_preference( 'myds' );
exec ctx_ddl.create_preference( 'myds', 'MULTI_COLUMN_DATASTORE' );
exec ctx_ddl.set_attribute( 'myds', 'COLUMNS', 'item_barcode, item_title, item_subtitle' );
CREATE INDEX i_index_test
   ON item (item_title)
   INDEXTYPE IS ctxsys.context
   PARAMETERS ( 'datastore myds' );
And script says:
CREATE INDEX PLSQL.I_INDEX_TEST ON PLSQL.ITEM
(ITEM_TITLE)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('datastore myds')
NOPARALLEL;
Where I can find datastore "myds" ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points