0 Replies Latest reply: Jul 21, 2011 1:23 AM by 876970 RSS

    How to use MULTI_COLUMN_DATASTORE for ORDDOC column

    876970
      I want to use MULTI_COLUMN_DATASTORE to index two column into one index. One column is varchar type ant the other one is ORDDOC type. I try to create the index as below:
      begin
      CTX_DDL.CREATE_PREFERENCE('TEST_MULTICOL', 'MULTI_COLUMN_DATASTORE');
      CTX_DDL.SET_ATTRIBUTE('TEST_MULTICOL', 'COLUMNS', 'KEYWORDS,doc_content.source.localdata');
      end;

      create index content_index on knta_document_tip_contents(doc_content.source.localdata) indextype is ctxsys.context PARAMETERS ('SYNC ( ON COMMIT) DATASTORE TEST_MULTICOL');

      but I get the error:
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-20000: Oracle Text error:
      DRG-12606: error encountered while parsing COLUMNS list
      ORA-00904: "DOC_CONTENT"."SOURCE"."LOCALDATA": invalid identifier

      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365

      And then I try to create PREFERENCE like this:
      begin
      CTX_DDL.CREATE_PREFERENCE('TEST_MULTICOL', 'MULTI_COLUMN_DATASTORE');
      CTX_DDL.SET_ATTRIBUTE('TEST_MULTICOL', 'COLUMNS', 'KEYWORDS,doc_content');
      end;

      then I create the index and got the error:
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-20000: Oracle Text error:
      DRG-12605: datatype of column 2 in COLUMNS list is not supported

      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365

      So I don't know how to use MULTI_COLUMN_DATASTORE for ORDDOC column.

      Would some one help me? Thanks!