2 Replies Latest reply: Nov 29, 2012 4:04 AM by 882532 RSS

    Oracle Text, multi_column_datastore describe index

    882532
      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" ?