Advertisement
mugs

create text index error

May 4th, 2015
298
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.67 KB | None | 0 0
  1. Error starting AT line : 1 IN command -
  2. CREATE INDEX MM_CATALOG_SEARCH_IDX1 ON MM_CATALOG_ITEM_SEARCH_T (CATALOG_DESC)
  3.         indextype IS ctxsys.ctxcat
  4. Error AT Command Line : 1 Column : 14
  5. Error report -
  6. SQL Error: ORA-29855: error occurred IN the execution OF ODCIINDEXCREATE routine
  7. ORA-20000: Oracle Text error:
  8. DRG-10700: preference does NOT exist: CTXSYS.DEFAULT_LEXER
  9. ORA-06512: AT "CTXSYS.DRUE", line 160
  10. ORA-06512: AT "CTXSYS.CATINDEXMETHODS", line 98
  11. 29855. 00000 -  "error occurred in the execution of ODCIINDEXCREATE routine"
  12. *Cause:    Failed TO successfully EXECUTE the ODCIIndexCreate routine.
  13. *Action:   CHECK TO see IF the routine has been coded correctly.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement