0 Replies Latest reply: Aug 16, 2013 12:47 PM by user521219 RSS

    Trying to create a CTXSYS.CONTEXT index

    user521219

      Hello,

      I'm trying to create a CTXSYS.CONTEXT index.

       

      CREATE INDEX SIGAXX.CATBIENSERVICIO_TIDX ON SIGAXX.CATALOGO_BIEN_SERVICIO

      (DESC_BSER_CAT)

      INDEXTYPE IS CTXSYS.CONTEXT

      PARAMETERS('DATASTORE CATBIENSERVICIO_PREF LEXER LEXER_SPANISH SYNC (ON COMMIT)')

      NOPARALLEL;

       

      and get error:

      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

      ORA-20000: Oracle Text error:

      DRG-10700: preference does not exist: CATBIENSERVICIO_PREF

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

      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

       

      However, if I query:

      select * from ctx_user_preference_values;

      I got:

       

      PRV_PREFERENCEPRV_ATTRIBUTEPRV_VALUE
      CATBIENSERVICIOCN_PREFCOLUMNSDESC_BSER_CAT,ABRE_BSER_CAT
      CATBIENSERVICIO_PREFCOLUMNSDESC_BSER_CAT,ABRE_BSER_CAT
      CODI_EMPL_PER_PREFCOLUMNSCODI_EMPL_PER
      DESCCONTCON_PREFCOLUMNSDESC_CONT_CON
      LEXER_SPANISHBASE_LETTERYES
      NOMB_CORT_PER_PREFCOLUMNSNOMB_CORT_PER

       

      So I see that preference CATBIENSERVICIO_PREF exist.

      What do I need to check else in order to create that index?

      How could I delete or create again this kind of preferences?