Scheduler job name for automatic sync. Only meaningful for AUTOMATIC sync and always null for other types of sync.

IDX_SYNC_MEMORY

VARCHAR2(100)

Sync memory size. Only meaningful for ONCOMMIT and AUTOMATIC types of sync. For MANUAL sync, this is always null.

IDX_SYNC_PARA_DEGREE

NUMBER

Degree of parallelism for sync. Only meaningful for the AUTOMATIC type of sync; always null for MANUAL and ONCOMMIT syncs.

IDX_SYNC_TYPE

VARCHAR2(20)

Type of synching: MANUAL, AUTOMATIC, or ONCOMMIT.

IDX_TABLE

VARCHAR2(30)

Table name.

IDX_TABLE_OWNER

VARCHAR2(30)

Owner of table.

IDX_TEXT_NAME

VARCHAR2(30)

Text column name.

IDX_TYPE

VARCHAR2(7)

Type of index: CONTEXT, CTXCAT, or CTXRULE.

G.4CTX_INDEX_ERRORS

This view displays the DML errors and is queryable by CTXSYS.

Column Name

Type

Description

ERR_INDEX_OWNER

VARCHAR2(30)

Index owner.

ERR_INDEX_NAME

VARCHAR2(30)

Name of index.

ERR_TIMESTAMP

DATE

Time of error.

ERR_TEXTKEY

VARCHAR2(18)

ROWID of errored document or name of errored operation (for example, ALTERINDEX)

ERR_TEXT

VARCHAR2(4000)

Error text.

G.5CTX_INDEX_OBJECTS

This view displays the objects that are used for each class in the index. It can be queried by CTXSYS.

Column Name

Type

Description

IXO_INDEX_OWNER

VARCHAR2(30)

Index owner.

IXO_INDEX_NAME

VARCHAR2(30)

Index name.

IXO_CLASS

VARCHAR2(30)

Class name.

IXO_OBJECT

VARCHAR2(30)

Object name.

G.6CTX_INDEX_PARTITIONS

This view displays all index partitions. It can be queried by CTXSYS.

Column Name

Type

Description

IXP_ID

NUMBER(38)

Index partition ID.

IXP_INDEX_OWNER

VARCHAR2(30)

Index owner.

IXP_INDEX_NAME

VARCHAR2(30)

Index name.

IXP_INDEX_PARTITION_NAME

VARCHAR2(30)

Index partition name.

IXP_SYNC_TYPE

VARCHAR2(20)

Type of synching: MANUAL, AUTOMATIC, or ONCOMMIT.

IXP_TABLE_OWNER

VARCHAR2(30)

Table owner.

IXP_TABLE_NAME

VARCHAR2(30)

Table name.

IXP_TABLE_PARTITION_NAME

VARCHAR2(30)

Table partition name.

IXP_DOCID_COUNT

NUMBER(38)

Number of documents associated with the partition.

IXP_STATUS

VARCHAR2(12)

Partition status.

G.7CTX_INDEX_SETS

This view displays all index set names. It can be queried by any user.

Column Name

Type

Description

IXS_OWNER

VARCHAR2(30)

Index set owner.

IXS_NAME

VARCHAR2(30)

Index set name.

G.8CTX_INDEX_SET_INDEXES

This view displays all the sub-indexes in an index set. It can be queried by any user.

Column Name

Type

Description

IXX_INDEX_SET_OWNER

VARCHAR2(30)

Index set owner.

IXX_INDEX_SET_NAME

VARCHAR2(30)

Index set name.

IXX_COLLIST

VARCHAR2(500)

Column list of the sub-index.

IXX_STORAGE

VARCHAR2(500)

Storage clause of the sub-index.

G.9CTX_INDEX_SUB_LEXERS

This view shows the sub-lexers for each language for each index. It can be queried by CTXSYS.

Column Name

Type

Description

ISL_INDEX_OWNER

VARCHAR2(30)

Index owner.

ISL_INDEX_NAME

VARCHAR2(30)

Index name.

ISL_LANGUAGE

VARCHAR2(30)

Language of sub-lexer

ISL_ALT_VALUE

VARCHAR2(30)

Alternate value of language.

ISL_OBJECT

VARCHAR2(30)

Name of lexer object used for this language.

G.10CTX_INDEX_SUB_LEXER_VALUES

Shows the sub-lexer attributes and their values. Accessible by CTXSYS.

Column Name

Type

Description

ISV_INDEX_OWNER

VARCHAR2(30)

Index owner.

ISV_INDEX_NAME

VARCHAR2(30)

Index name.

ISV_LANGUAGE

VARCHAR2(30)

Language of sub-lexer

ISV_OBJECT

VARCHAR2(30)

Name of lexer object used for this language.

ISV_ATTRIBUTE

VARCHAR2(30)

Name of sub-lexer attribute.

ISV_VALUE

VARCHAR2(500)

Value of attribute of sub-lexer.

G.11CTX_INDEX_VALUES

This view displays attribute values for each object used in indexes. This view is queryable by CTXSYS.

Column Name

Type

Description

IXV_INDEX_OWNER

VARCHAR2(30)

Index owner.

IXV_INDEX_NAME

VARCHAR2(30)

Index name.

IXV_CLASS

VARCHAR2(30)

Class name.

IXV_OBJECT

VARCHAR2(30)

Object name.

IXV_ATTRIBUTE

VARCHAR2(30)

Attribute name

IXV_VALUE

VARCHAR2(500)

Attribute value.

G.12CTX_OBJECTS

This view displays all of the Text objects registered in the Text data dictionary. This view can be queried by any user.

Column Name

Type

Description

OBJ_CLASS

VARCHAR2(30)

Object class (Datastore, Filter, Lexer, and so on)

OBJ_NAME

VARCHAR2(30)

Object name

OBJ_DESCRIPTION

VARCHAR2(80)

Object description

G.13CTX_OBJECT_ATTRIBUTES

This view displays the attributes that can be assigned to preferences of each object. It can be queried by all users.

Column Name

Type

Description

OAT_CLASS

VARCHAR2(30)

Object class (Data Store, Filter, Lexer, and so on)

OAT_OBJECT

VARCHAR2(30)

Object name

OAT_ATTRIBUTE

VARCHAR2(64)

Attribute name

OAT_DESCRIPTION

VARCHAR2(80)

Description of attribute

OAT_REQUIRED

VARCHAR2(1)

Required attribute, either Y or N.

OAT_STATIC

VARCHAR2(1)

Not currently used.

OAT_DATATYPE

VARCHAR2(64)

Attribute datatype. The value PROCEDURE indicates that the attribute of the object should be a stored procedure name.

OAT_DEFAULT

VARCHAR2(500)

Default value for attribute.

OAT_MIN

NUMBER

Minimum value.

OAT_MAX

NUMBER

Maximum value.

OAT_MAX_LENGTH

NUMBER

Maximum length.

G.14CTX_OBJECT_ATTRIBUTE_LOV

This view displays the allowed values for certain object attributes provided by Oracle Text. It can be queried by all users.

Column Name

Type

Description

OAL_CLASS

NUMBER(38)

Class of object.

OAL_OBJECT

VARCHAR2(30)

Object name.

OAL_ATTRIBUTE

VARCHAR2(32)

Attribute name.

OAl_LABEL

VARCHAR2(30)

Attribute value label.

OAL_VALUE

VARCHAR2(64)

Attribute value.

OAL_DESCRIPTION

VARCHAR2(80)

Attribute value description.

G.15CTX_ORDER_BY_COLUMNS

This view displays the ORDERBY columns registered in the Text data dictionary. It can be queried by any user.

Column Name

Type

Description

OBC_INDEX_OWNER

VARCHAR2(30)

Index owner

OBC_INDEX_NAME

VARCHAR2(30)

Index name

OBC_TABLE_OWNER

VARCHAR2(30)

Table owner

OBC_TABLE_NAME

VARCHAR2(30)

Table name

OBC_COLUMN_NAME

VARCHAR2(236)

Column name

OBC_COLUMN_POSITION

VARCHAR2(30)

Column position

OBC_COLUMN_TYPE

VARCHAR2(30)

Column type

OBC_SECTION_NAME

VARCHAR2(30)

Section name

OBC_SECTION_TYPE

VARCHAR2(30)

Section type

OBC_SECTION_ID

NUMBER

Section ID

OBC_SORT_ORDER

VARCHAR2(8)

Sort order

G.16CTX_PARAMETERS

This view displays all system-defined parameters as defined by CTXSYS. It can be queried by any user.

Column Name

Type

Description

PAR_NAME

VARCHAR2(30)

Parameter name:

max_index_memory

ctx_doc_key_type

default_index_memory

default_datastore

default_filter_binary

default_filter_text

default_filter_file

default_section_html

default_section_xml

default_section_text

default_lexer

default_stoplist

default_storage

default_wordlist

default_ctxcat_lexer

default_ctxcat_index_set

default_ctxcat_stoplist

default_ctxcat_storage

default_ctxcat_wordlist

default_ctxrule_lexer

default_ctxrule_stoplist

default_ctxrule_storage

default_ctxrule_wordlist

log_directory

file_access_role

PAR_VALUE

VARCHAR2(500)

Parameter value. For max_index_memory and default_index_memory, PAR_VALUE stores a string consisting of the memory amount. For the other parameter names, PAR_VALUE stores the names of the preferences used as defaults for index creation.

G.17CTX_PENDING

This view displays a row for each of the user's entries in the DML Queue. It can be queried by CTXSYS.

Column Name

Type

Description

PND_INDEX_OWNER

VARCHAR2(30)

Index owner.

PND_INDEX_NAME

VARCHAR2(30)

Name of index.

PND_PARTITION_NAME

VARCHAR2(30)

Name of partition for local partition indexes. NULL for normal indexes.

PND_ROWID

ROWID

ROWID to be indexed

PND_TIMESTAMP

DATE

Time of modification

G.18CTX_PREFERENCES

This view displays preferences created by Oracle Text users, as well as all the system-defined preferences included with Oracle Text. The view contains one row for each preference. It can be queried by all users.

Column Name

Type

Description

PRE_OWNER

VARCHAR2(30)

Username of preference owner.

PRE_NAME

VARCHAR2(30)

Preference name.

PRE_CLASS

VARCHAR2(30)

Preference class.

PRE_OBJECT

VARCHAR2(30)

Object used.

G.19CTX_PREFERENCE_VALUES

This view displays the values assigned to all the preferences in the Text data dictionary. The view contains one row for each value. It can be queried by all users.

Column Name

Type

Description

PRV_OWNER

VARCHAR2(30)

Username of preference owner.

PRV_PREFERENCE

VARCHAR2(30)

Preference name.

PRV_ATTRIBUTE

VARCHAR2(64)

Attribute name

PRV_VALUE

VARCHAR2(500)

Attribute value

G.20CTX_SECTIONS

This view displays information about all the sections that have been created in the Text data dictionary. It can be queried by any user.

Column Name

Type

Description

SEC_OWNER

VARCHAR2(30)

Owner of the section group.

SEC_SECTION_GROUP

VARCHAR2(30)

Name of the section group.

SEC_TYPE

VARCHAR2(30)

Type of section, either ZONE, FIELD, SPECIAL, ATTR, STOP.

SEC_ID

NUMBER

Section ID.

SEC_NAME

VARCHAR2(30)

Name of section.

SEC_TAG

VARCHAR2(64)

Section tag

SEC_VISIBLE

VARCHAR2(1)

Y or N visible indicator for field sections only.

SEC_DATATYPE

VARCHAR2(30)

Shows the datatype name (NUMBER, VARCHAR2, DATE or RAW) if the section is an SDATA section. Otherwise, it is NULL.

G.21CTX_SECTION_GROUPS

This view displays information about all the section groups that have been created in the Text data dictionary. It can be queried by any user.

Column Name

Type

Description

SGP_OWNER

VARCHAR2(30)

Owner of section group.

SGP_NAME

VARCHAR2(30)

Name of section group.

SGP_TYPE

VARCHAR2(30)

Type of section group

G.22CTX_SQES

This view displays the definitions for all SQEs that have been created by users. It can be queried by all users.

Column Name

Type

Description

SQE_OWNER

VARCHAR2(30)

Owner of SQE.

SQE_NAME

VARCHAR2(30)

Name of SQE.

SQE_QUERY

CLOB

Query Text.

G.23CTX_STOPLISTS

This view displays stoplists. Queryable by all users.

Column Name

Type

Description

SPL_OWNER

VARCHAR2(30)

Owner of stoplist.

SPL_NAME

VARCHAR2(30)

Name of stoplist.

SPL_COUNT

NUMBER

Number of stopwords

SPL_TYPE

VARCHAR2(30)

Type of stoplist, MULTI or BASIC.

G.24CTX_STOPWORDS

This view displays the stopwords in each stoplist. Queryable by all users.

Column Name

Type

Description

SPW_OWNER

VARCHAR2(30)

Stoplist owner.

SPW_STOPLIST

VARCHAR2(30)

Stoplist name.

SPW_TYPE

VARCHAR2(10)

Stop type, either STOP_WORD, STOP_CLASS, STOP_THEME.

SPW_WORD

VARCHAR2(80)

Stopword.

SPW_LANGUAGE

VARCHAR2(30)

Stopword language.

G.25CTX_SUB_LEXERS

This view contains information on multi-lexers and the sub-lexer preferences they contain. It can be queried by any user.

Column Name

Type

Description

SLX_OWNER

VARCHAR2(30)

Owner of the multi-lexer preference.

SLX_NAME

VARCHAR2(30)

Name of the multi-lexer preference.

SLX_LANGUAGE

VARCHAR2(30)

Language of the referenced lexer (full name, not abbreviation).

SLX_ALT_VALUE

VARCHAR2(30)

An alternate value for the language.

SLX_SUB_OWNER

VARCHAR2(30)

Owner of the sub-lexer.

SLX_SUB_NAME

VARCHAR2(30)

Name of the sub-lexer.

G.26CTX_THESAURI

This view displays information about all the thesauri that have been created in the Text data dictionary. It can be queried by any user.

Column Name

Type

Description

THS_OWNER

VARCHAR2(30)

Thesaurus owner.

THS_NAME

VARCHAR2(30)

Thesaurus name.

G.27CTX_THES_PHRASES

This view displays phrase information for all thesauri in the Text data dictionary. It can be queried by any user.

Column Name

Type

Description

THP_THESAURUS

VARCHAR2(30)

Thesaurus name.

THP_PHRASE

VARCHAR2(256)

Thesaurus phrase.

THP_QUALIFIER

VARCHAR2(256)

Thesaurus qualifier.

THP_SCOPE_NOTE

VARCHAR2(2000)

Thesaurus scope notes.

G.28CTX_TRACE_VALUES

This view contains one row for each active trace, and shows the current value of each trace.

Column Name

Type

Description

TRC_ID

BINARY_INTEGER

Trace ID.

TRC_VALUE

NUMBER

Current trace value.

G.29CTX_USER_ FILTER_BY_COLUMNS

This view displays all FILTERBY columns registered in the Text data dictionary for the current user. It can be queried by any user.

Column Name

Type

Description

FBC_INDEX_NAME

VARCHAR2(30)

Index name

FBC_TABLE_OWNER

VARCHAR2(30)

Table owner name

FBC_TABLE_NAME

VARCHAR2(30)

Table name

FBC_COLUMN_NAME

VARCHAR2(256)

Column name

FBC_COLUMN_TYPE

VARCHAR2(30)

Column type

FBC_SECTION_TYPE

VARCHAR2(30)

Section type

FBC_SECTION_NAME

VARCHAR2(30)

Section name

FBC_SECTION_ID

NUMBER

Section ID

G.30CTX_USER_INDEXES

This view displays all indexes that are registered in the Text data dictionary for the current user. It can be queried by all users.

Column Name

Type

Description

IDX_CHARSET_COLUMN

VARCHAR2(256)

Name of the charset column of base table.

IDX_DOCID_COUNT

NUMBER

Number of documents indexed.

IDX_FORMAT_COLUMN

VARCHAR2(256)

Name of the format column of base table.

IDX_ID

NUMBER

Internal index ID.

IDX_KEY_NAME

VARCHAR(256)

Primary key column(s).

IDX_LANGUAGE_COLUMN

VARCHAR2(256)

Name of the language column of base table.

IDX_NAME

VARCHAR2(30)

Name of index.

IDX_STATUS

VARCHAR2(12)

Status, either INDEXED or INDEXING.

IDX_SYNC_INTERVAL

VARCHAR2(2000)

This is the interval string required by scheduler job. Only meaningful for AUTOMATIC sync. Always null for MANUAL and ONCOMMIT sync.

IDX_SYNC_JOBNAME

VARCHAR2(50)

This is the scheduler job name for automatic sync. Only meaningful for AUTOMATIC sync and always null for other types of sync.

IDX_SYNC_MEMORY

VARCHAR2(100)

The sync memory size. Only meaningful for ONCOMMIT and AUTOMATIC types of sync. For MANUAL sync, this is always null.

IDX_SYNC_PARA_DEGREE

NUMBER

Degree of parallelism for sync. Only meaningful for the AUTOMATIC type of sync; always null for MANUAL and ONCOMMIT syncs.

IDX_SYNC_TYPE

VARCHAR2(20)

Type of synching: AUTOMATIC, MANUAL or ONCOMMIT.

IDX_TABLE

VARCHAR2(30)

Table name.

IDX_TABLE_OWNER

VARCHAR2(30)

Owner of table.

IDX_TEXT_NAME

VARCHAR2(30)

Text column name.

IDX_TYPE

VARCHAR2(30)

Type of index: CONTEXT, CTXCAT, or CTXRULE.

G.31CTX_USER_INDEX_ERRORS

This view displays the indexing errors for the current user and is queryable by all users.

Column Name

Type

Description

ERR_INDEX_NAME

VARCHAR2(30)

Name of index.

ERR_TIMESTAMP

DATE

Time of error.

ERR_TEXTKEY

VARCHAR2(18)

ROWID of errored document or name of errored operation (for example, ALTERINDEX)

ERR_TEXT

VARCHAR2(4000)

Error text.

G.32CTX_USER_INDEX_OBJECTS

This view displays the preferences that are attached to the indexes defined for the current user. It can be queried by all users.

Column Name

Type

Description

IXO_INDEX_NAME

VARCHAR2(30)

Name of index.

IXO_CLASS

VARCHAR2(30)

Object name

IXO_OBJECT

VARCHAR2(80)

Object description

G.33CTX_USER_INDEX_PARTITIONS

This view displays all index partitions for the current user. It is queryable by all users.

Column Name

Type

Description

IXP_DOCID_COUNT

NUMBER(38)

Number of documents associated with the index partition.

IXP_ID

NUMBER(38)

Index partition ID.

IXP_INDEX_NAME

VARCHAR2(30)

Index name.

IXP_INDEX_PARTITION_NAME

VARCHAR2(30)

Index partition name.

IDX_SYNC_INTERVAL

VARCHAR2(2000)

This is the interval string required by scheduler job. Only meaningful for AUTOMATIC sync. Always null for MANUAL and ONCOMMIT sync.

IDX_SYNC_JOBNAME

VARCHAR2(50)

This is the scheduler job name for automatic sync. It is only meaningful for AUTOMATIC sync and always null for other types of sync.

IDX_SYNC_MEMORY

VARCHAR2(100)

The sync memory size. Only meaningful for ONCOMMIT and AUTOMATIC types of sync. For MANUAL sync, this is always null.

IDX_SYNC_PARA_DEGREE

NUMBER

Degree of parallelism for sync. Only meaningful for the AUTOMATIC type of sync; always null for MANUAL and ONCOMMIT syncs.

IDX_SYNC_TYPE

VARCHAR2(20)

Type of synching: AUTOMATIC, MANUAL or ONCOMMIT.

IXP_STATUS

VARCHAR2(12)

Partition status.

IXP_TABLE_OWNER

VARCHAR2(30)

Table owner.

IXP_TABLE_NAME

VARCHAR2(30)

Table name.

IXP_TABLE_PARTITION_NAME

VARCHAR2(30)

Table partition name.

G.34CTX_USER_INDEX_SETS

This view displays all index set names that belong to the current user. It is queryable by all users.

Column Name

Type

Description

IXS_NAME

VARCHAR2(30)

Index set name.

G.35CTX_USER_INDEX_SET_INDEXES

This view displays all the indexes in an index set that belong to the current user. It is queryable by all users.

Column Name

Type

Description

IXX_INDEX_SET_NAME

VARCHAR2(30)

Index set name.

IXX_COLLIST

VARCHAR2(500)

Column list of the index.

IXX_STORAGE

VARCHAR2(500)

Storage clause of the index.

G.36CTX_USER_INDEX_SUB_LEXERS

This view shows the sub-lexers for each language for each index for the querying user. This view can be queried by all users.

Column Name

Type

Description

ISL_INDEX_NAME

VARCHAR2(30)

Index name.

ISL_LANGUAGE

VARCHAR2(30)

Language of sub-lexer

ISL_ALT_VALUE

VARCHAR2(30)

Alternate value of language.

ISL_OBJECT

VARCHAR2(30)

Name of lexer object used for this language.

G.37CTX_USER_INDEX_SUB_LEXER_VALS

Shows the sub-lexer attributes and their values for the querying user. This view can be queried by all users.

Column Name

Type

Description

ISV_INDEX_NAME

VARCHAR2(30)

Index name.

ISV_LANGUAGE

VARCHAR2(30)

Language of sub-lexer

ISV_OBJECT

VARCHAR2(30)

Name of lexer object used for this language.

ISV_ATTRIBUTE

VARCHAR2(30)

Name of sub-lexer attribute.

ISV_VALUE

VARCHAR2(500)

Value of sub-lexer attribute.

G.38CTX_USER_INDEX_VALUES

This view displays attribute values for each object used in indexes for the current user. This view is queryable by all users.

Column Name

Type

Description

IXV_INDEX_NAME

VARCHAR2(30)

Index name.

IXV_CLASS

VARCHAR2(30)

Class name.

IXV_OBJECT

VARCHAR2(30)

Object name.

IXV_ATTRIBUTE

VARCHAR2(30)

Attribute name

IXV_VALUE

VARCHAR2(500)

Attribute value.

G.39CTX_USER_ORDER_BY_COLUMNS

This view displays all ORDERBY columns registered in the Text data dictionary for the current user. It can be queried by any user.

Column Name

Type

Description

OBC_INDEX_NAME

VARCHAR2(30)

Index name

OBC_TABLE_OWNER

VARCHAR2(30)

Table owner

OBC_TABLE_NAME

VARCHAR2(30)

Table name

OBC_COLUMN_NAME

VARCHAR2(236)

Column name

OBC_COLUMN_POSITION

VARCHAR2(30)

Column position

OBC_COLUMN_TYPE

VARCHAR2(30)

Column type

OBC_SECTION_NAME

VARCHAR2(30)

Section name

OBC_SECTION_TYPE

VARCHAR2(30)

Section type

OBC_SECTION_ID

NUMBER

Section ID

OBC_SORT_ORDER

VARCHAR2(8)

Sort order

G.40CTX_USER_PENDING

This view displays a row for each of the user's entries in the DML Queue. It can be queried by all users.

Column Name

Type

Description

PND_INDEX_NAME

VARCHAR2(30)

Name of index.

PND_PARTITION_NAME

VARCHAR2(30)

Name of partition for local partition indexes. NULL for normal indexes.

PND_ROWID

ROWID

Rowid to be indexed.

PND_TIMESTAMP

DATE

Time of modification.

G.41CTX_USER_PREFERENCES

This view displays all preferences defined by the current user. It can be queried by all users.

Column Name

Type

Description

PRE_NAME

VARCHAR2(30)

Preference name.

PRE_CLASS

VARCHAR2(30)

Preference class.

PRE_OBJECT

VARCHAR2(30)

Object used.

G.42CTX_USER_PREFERENCE_VALUES

This view displays all the values for preferences defined by the current user. It can be queried by all users.

Column Name

Type

Description

PRV_PREFERENCE

VARCHAR2(30)

Preference name.

PRV_ATTRIBUTE

VARCHAR2(64)

Attribute name

PRV_VALUE

VARCHAR2(500)

Attribute value

G.43CTX_USER_SECTIONS

This view displays information about the sections that have been created in the Text data dictionary for the current user. It can be queried by all users.

Column Name

Type

Description

SEC_DATATYPE

VARCHAR2(30)

Shows the datatype name (NUMBER, VARCHAR2, DATE or RAW) if the section is an SDATA section. Otherwise, it is NULL.

SEC__SECTION_GROUP

VARCHAR2(30)

Name of the section group.

SEC_TYPE

VARCHAR2(30)

Type of section, either ZONE, FIELD, SPECIAL, STOP, or ATTR.

SEC_ID

NUMBER

Section ID.

SEC_NAME

VARCHAR2(30)

Name of section.

SEC_TAG

VARCHAR2(64)

Section tag

SEC_VISIBLE

VARCHAR2(1)

Y or N visible indicator for field sections.

G.44CTX_USER_SECTION_GROUPS

This view displays information about the section groups that have been created in the Text data dictionary for the current user. It can be queried by all users.

Column Name

Type

Description

SGP_NAME

VARCHAR2(30)

Name of section group.

SGP_TYPE

VARCHAR2(30)

Type of section group

G.45CTX_USER_SQES

This view displays the definitions for all system and session SQEs that have been created by the current user. It can be viewed by all users.

Column Name

Type

Description

SQE_OWNER

VARCHAR2(30)

Owner of SQE.

SQE_NAME

VARCHAR2(30)

Name of SQE.

SQE_QUERY

CLOB

Query Text.

G.46CTX_USER_STOPLISTS

This view displays stoplists for current user. It is queryable by all users.

Column Name

Type

Description

SPL_NAME

VARCHAR2(30)

Name of stoplist.

SPL_COUNT

NUMBER

Number of stopwords

SPL_TYPE

VARCHAR2(30)

Type of stoplist, MULTI or BASIC.

G.47CTX_USER_STOPWORDS

This view displays stopwords in each stoplist for current user. Queryable by all users.

Column Name

Type

Description

SPW_STOPLIST

VARCHAR2(30)

Stoplist name.

SPW_TYPE

VARCHAR2(10)

Stop type, either STOP_WORD, STOP_CLASS, STOP_THEME.

SPW_WORD

VARCHAR2(80)

Stopword.

SPW_LANGUAGE

VARCHAR2(30)

Stopword language.

G.48CTX_USER_SUB_LEXERS

For the current user, this view contains information on multi-lexers and the sub-lexer preferences they contain. It can be queried by any user.

Column Name

Type

Description

SLX_NAME

VARCHAR2(30)

Name of the multi-lexer preference.

SLX_LANGUAGE

VARCHAR2(30)

Language of the referenced lexer (full name, not abbreviation).

SLX_ALT_VALUE

VARCHAR2(30)

An alternate value for the language.

SLX_SUB_OWNER

VARCHAR2(30)

Owner of the sub-lexer.

SLX_SUB_NAME

VARCHAR2(30)

Name of the sub-lexer.

G.49CTX_USER_THESAURI

This view displays the information about all of the thesauri that have been created in the system by the current user. It can be viewed by all users.

Column Name

Type

Description

THS_NAME

VARCHAR2(30)

Thesaurus name

G.50CTX_USER_THES_PHRASES

This view displays the phrase information of all thesaurus owned by the current user. It can be queried by all users.

Column Name

Type

Description

THP_THESAURUS

VARCHAR2(30)

Thesaurus name.

THP_PHRASE

VARCHAR2(256)

Thesaurus phrase.

THP_QUALIFIER

VARCHAR2(256)

Phrase qualifier.

THP_SCOPE_NOTE

VARCHAR2(2000)

Scope note of the phrase.

G.51CTX_VERSION

This view displays the CTXSYS data dictionary and code version number information.

Column Name

Type

Description

VER_DICT

CHAR(9)

The CTXSYS data dictionary version number.

VER_CODE

VARCHAR2(9)

The version number of the code linked in to the Oracle Database shadow process.

This column fetches the version number for linked-in code. Thus, use this column to detect and verify patch releases.

Scripting on this page enhances content navigation, but does not change the content in any way.