Retrieving user-defined Lexer attributes

Paulo

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

Roger Ford-Oracle

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

Roger Ford-Oracle

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