This discussion is archived
3 Replies Latest reply: Oct 17, 2012 12:47 AM by Herald ten Dam RSS

error while creating index

sachinpawan Newbie
Currently Being Moderated
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

Legend

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