Forum Stats

  • 3,825,196 Users
  • 2,260,479 Discussions
  • 7,896,435 Comments

Discussions

Retrieving user-defined Lexer attributes

Paulo
Paulo Member Posts: 80 Blue Ribbon
edited Jun 20, 2017 1:03PM in Text

Hi,

How may I see the attributes that have been setted for an user defined Lexer?

I found the lexer with "CTXSYS.CTX_PREFERENCES", but all I see is owner, name and the lexer is based on.

Regards.

Paulo

Best Answer

  • Roger Ford-Oracle
    Roger Ford-Oracle Member Posts: 1,132 Employee
    edited Jun 20, 2017 12:51PM Answer ✓

    A USER_LEXER only has three attributes. See here

    The easiest way to see what those attributes are set to for a particular index is to call ctx_report.create_index_script.

    In SQL*Plus I usually call it like this:

    define indexname=MY_INDEX_NAMEvariable theclob clobexec dbms_lob.createtemporary(:theclob, true)set pagesize 0set linesize 255set long 50000set longchunksize 50000set heading offset trimspool onspool indexdetails.txtexec ctx_report.create_index_script(index_name=>'&indexname.', report=>:theclob);print theclob

Answers

  • Roger Ford-Oracle
    Roger Ford-Oracle Member Posts: 1,132 Employee
    edited Jun 20, 2017 12:51PM Answer ✓

    A USER_LEXER only has three attributes. See here

    The easiest way to see what those attributes are set to for a particular index is to call ctx_report.create_index_script.

    In SQL*Plus I usually call it like this:

    define indexname=MY_INDEX_NAMEvariable theclob clobexec dbms_lob.createtemporary(:theclob, true)set pagesize 0set linesize 255set long 50000set longchunksize 50000set heading offset trimspool onspool indexdetails.txtexec ctx_report.create_index_script(index_name=>'&indexname.', report=>:theclob);print theclob
This discussion has been closed.