G
Views

This appendix lists all of the views provided by Oracle Text. The system provides the following views:

CTX_CLASSES

This view displays all the preference categories registered in the Text data dictionary. It can be queried by any user.

Column Name	Type	Description
`CLA_NAME`	`VARCHAR2(30)`	Class name
`CLA_DESCRIPTION`	`VARCHAR2(80)`	Class description

CTX_INDEXES

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

Column Name	Type	Description
`IDX_ID`	`NUMBER`	Internal index id.
`IDX_OWNER`	`VARCHAR2(30)`	Owner of index.
`IDX_NAME`	`VARCHAR2(30)`	Name of index.
`IDX_TABLE_OWNER`	`VARCHAR2(30)`	Owner of table.
`IDX_TABLE`	`VARCHAR2(30)`	Table name.
`IDX_KEY_NAME`	`VARCHAR2(256)`	Primary key column(s).
`IDX_TEXT_NAME`	`VARCHAR2(30)`	Text column name.
`IDX_DOCID_COUNT`	`NUMBER`	Number of documents indexed.
`IDX_STATUS`	`VARCHAR2(12)`	Status.
`IDX_LANGUAGE_COLUMN`	`VARCHAR2(256)`	Name of the language column in base table.
`IDX_FORMAT_COLUMN`	`VARCHAR2(256)`	Name of the format column in base table.
`IDX_CHARSET_COLUMN`	`VARCHAR2(256)`	Name of the charset column in base table.

CTX_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 (i.e. ALTER INDEX)
`ERR_TEXT`	`VARCHAR2(4000)`	Error text.

CTX_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.

CTX_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_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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, etc.)
`OBJ_NAME`	`VARCHAR2(30)`	Object name
`OBJ_DESCRIPTION`	`VARCHAR2(80)`	Object description

CTX_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, etc.)
`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
`OAT_DEFAULT`	`VARCHAR2(500)`	Default value for attribute
`OAT_MIN`	`NUMBER`	Minimum value.
`OAT_MAX`	`NUMBER`	Maximum value.
`OAT_MAX_LENGTH`	`NUMBER`	Maximum length.

CTX_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.

CTX_PARAMETERS

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

Column Name Type Description

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.

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.

CTX_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

CTX_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.

CTX_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

CTX_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.

CTX_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

CTX_SERVERS

This view displays ctxsrv servers that are currently active. It can be queried only by CTXSYS.

Column Name	Type	Description
`SER_NAME`	`VARCHAR2(60)`	Server identifier
`SER_STATUS`	`VARCHAR2(8)`	Server status (IDLE, RUN, EXIT)
`SER_ADMMBX`	`VARCHAR2(60)`	Admin pipe mailbox name for server.
`SER_OOBMBX`	`VARCHAR2(60)`	Out-of-band mailbox name for server.
`SER_SESSION`	`NUMBER`	No Longer Used
`SER_AUDSID`	`NUMBER`	Server audit session ID
`SER_DBID`	`NUMBER`	Server database ID
`SER_PROCID`	`VARCHAR2(10)`	No Longer Used
`SER_PERSON_MASK`	`VARCHAR2(30)`	Personality mask for server
`SER_STARTED_AT`	`DATE`	Date on which server was started
`SER_IDLE_TIME`	`NUMBER`	Idle time, in seconds, for server
`SER_DB_INSTANCE`	`VARCHAR2(10)`	Database instance ID
`SER_MACHINE`	`VARCHAR2(64)`	Name of host machine on which server is running

CTX_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`	`VARCHAR2(2000)`	Query Text

CTX_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.

CTX_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.

CTX_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.

CTX_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

CTX_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.

CTX_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_ID`	`NUMBER`	Internal index id.
`IDX_NAME`	`VARCHAR2(30)`	Name of index.
`IDX_TYPE`	`VARCHAR2(30)`	Type of index: CONTEXT, CTXCAT, OR CTXRULE
`IDX_TABLE_OWNER`	`VARCHAR2(30)`	Owner of table.
`IDX_TABLE`	`VARCHAR2(30)`	Table name.
`IDX_KEY_NAME`	`VARCHAR2(256)`	Primary key column(s).
`IDX_TEXT_NAME`	`VARCHAR2(30)`	Text column name.
`IDX_DOCID_COUNT`	`NUMBER`	Number of documents indexed.
`IDX_STATUS`	`VARCHAR2(12)`	Status, either INDEXED or INDEXING.
`IDX_LANGUAGE_COLUMN`	`VARCHAR2(256)`	Name of the language column of base table.
`IDX_FORMAT_COLUMN`	`VARCHAR2(256)`	Name of the format column of base table.
`IDX_CHARSET_COLUMN`	`VARCHAR2(256)`	Name of the charset column of base table.

CTX_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 (i.e. ALTER INDEX)
`ERR_TEXT`	`VARCHAR2(4000)`	Error text.

CTX_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

CTX_USER_INDEX_PARTITIONS

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

Column Name	Type	Description
`IXP_ID`	`NUMBER(38)`	Index partition id.
`IXP_INDEX_NAME`	`VARCHAR2(30)`	Index name.
`IXP_INDEX_PARTITION_NAME`	`VARCHAR2(30)`	Index partition name.
`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 index partition.
`IXP_STATUS`	`VARCHAR2(12)`	Partition status.

CTX_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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.

CTX_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

CTX_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__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.

CTX_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

CTX_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`	`VARCHAR2(2000)`	Query Text

CTX_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.

CTX_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.

CTX_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.

CTX_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

CTX_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.

CTX_VERSION

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