3 Replies Latest reply: Oct 17, 2012 2:47 AM by Herald ten Dam RSS

    error while creating index

    sachinpawan
      Hi all,

      when i try to create index , getting error , how can i fix this error?
      ICBS4>CREATE INDEX ICBS.PHPR_B_FULL_NAME_INDEX ON ICBS.BBSD_PHYSICAL_PERSONS
        2  (PHPR_B_FULL_NAME)
        3  INDEXTYPE IS CTXSYS.CONTEXT
        4  PARAMETERS('Wordlist wildcard_pref SYNC (ON COMMIT)')
        5  NOPARALLEL;
      CREATE INDEX ICBS.PHPR_B_FULL_NAME_INDEX ON ICBS.BBSD_PHYSICAL_PERSONS
      *
      ERROR at line 1:
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine 
      ORA-20000: Oracle Text error: 
      DRG-10700: preference does not exist: wildcard_pref 
      ORA-06512: at "CTXSYS.DRUE", line 160 
      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366 
      thanks in advance
      best regards
      pa1