Skip Headers
Oracle® Text Reference
11g Release 2 (11.2)

E24436-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

G Oracle Text Views

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

G.1 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

G.2 CTX_FILTER_BY_COLUMNS

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

Column Name Type Description
FBC_INDEX_OWNER VARCHAR2(30) Index owner name
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.3 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_CHARSET_COLUMN VARCHAR2(256) Name of the charset column in base table
IDX_DOCID_COUNT NUMBER Number of documents indexed
IDX_FORMAT_COLUMNS VARCHAR2(256) Name of the format column in base table
IDX_ID NUMBER Internal index ID
IDX_KEY_NAME VARCHAR2(256) Primary key column(s)
IDX_LANGUAGE_COLUMN VARCHAR2(256) Name of the language column in base table
IDX_NAME VARCHAR2(30) Name of index
IDX_OWNER VARCHAR2(30) Owner of index
IDX_STATUS VARCHAR2(12) Status
IDX_SYNC_INTERVAL VARCHAR2(2000) Interval string required by scheduler job. Only meaningful for AUTOMATIC sync. Always null for MANUAL and ON COMMIT sync.
IDX_SYNC_JOBNAME VARCHAR2(50) 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 ON COMMIT 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 ON COMMIT syncs.
IDX_SYNC_TYPE VARCHAR2(20) Type of synching: MANUAL, AUTOMATIC, or ON COMMIT
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.4 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 (for example, ALTER INDEX)
ERR_TEXT VARCHAR2(4000) Error text

G.5 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

G.6 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_SYNC_TYPE VARCHAR2(20) Type of synching: MANUAL, AUTOMATIC, or ON COMMIT
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.7 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

G.8 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

G.9 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

G.10 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

G.11 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

G.12 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, and so on)
OBJ_NAME VARCHAR2(30) Object name
OBJ_DESCRIPTION VARCHAR2(80) Object description

G.13 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, 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.14 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

G.15 CTX_ORDER_BY_COLUMNS

This view displays the ORDER BY 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.16 CTX_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.17 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

G.18 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

G.19 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

G.20 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
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.21 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

G.22 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 CLOB Query Text

G.23 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

G.24 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

G.25 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

G.26 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

G.27 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

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

Note:

The error "ORA-00955: name is already used by an existing object" can safely be ignored if this error is raised in the post-install steps for patch releases. This may occur when this view is present in the database being patched.

G.29 CTX_USER_ FILTER_BY_COLUMNS

This view displays all FILTER BY 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.30 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_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 ON COMMIT 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 ON COMMIT 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 ON COMMIT syncs.
IDX_SYNC_TYPE VARCHAR2(20) Type of synching: AUTOMATIC, MANUAL or ON COMMIT
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.31 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 (for example, ALTER INDEX)
ERR_TEXT VARCHAR2(4000) Error text

G.32 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

G.33 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_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 ON COMMIT 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 ON COMMIT 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 ON COMMIT syncs.
IDX_SYNC_TYPE VARCHAR2(20) Type of synching: AUTOMATIC, MANUAL or ON COMMIT
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.34 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

G.35 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

G.36 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

G.37 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

G.38 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

G.39 CTX_USER_ORDER_BY_COLUMNS

This view displays all ORDER BY 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.40 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

G.41 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

G.42 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

G.43 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_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.44 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

G.45 CTX_USER_SQES

This view displays the definitions of all persistent duration SQEs that have been created by the current user. In other words, it does not display session duration SQEs.

Column Name Type Description
SQE_OWNER VARCHAR2(30) Owner of SQE
SQE_NAME VARCHAR2(30) Name of SQE
SQE_QUERY CLOB Query text

G.46 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

G.47 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

G.48 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

G.49 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

G.50 CTX_USER_THES_PHRASES

This view displays the phrase information of all thesauri 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.51 CTX_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.