G Oracle Text Views
This appendix lists all of the views provided by Oracle Text. The system provides the following views:
G.1 CTX_ALEXER_DICTS
This view displays all dictionaries created by any user. This view can be queried by CTXSYS.
Column Name | Type | Description |
---|---|---|
|
|
Name of the dictionary owner |
|
|
Name of the dictionary |
|
|
Language of the dictionary |
G.2 CTX_AUTO_OPTIMIZE_INDEXES
This view displays all the indexes that are registered for auto optimization. It can be queried by CTXSYS
.
Column Name | Type | Description |
---|---|---|
|
|
Index owner |
|
|
Index name |
|
|
Partition name |
Note:
In Oracle Database Release 21c, the procedures
ADD_AUTO_OPTIMIZE
and
REMOVE_AUTO_OPTIMIZE
, and the views
CTX_AUTO_OPTIMIZE_INDEXES
,
CTX_USER_AUTO_OPTIMIZE_INDEXES
and
CTX_AUTO_OPTIMIZE_STATUS
are deprecated.
G.3 CTX_AUTO_OPTIMIZE_STATUS
This view displays the status of auto optimization jobs. It can be queried by CTXSYS
.
Column Name | Type | Description |
---|---|---|
|
|
Time at which the auto optimization job started |
|
|
Status of the auto optimization job |
|
|
Errors raised by the auto optimization job |
Note:
In Oracle Database Release 21c, the procedures
ADD_AUTO_OPTIMIZE
and
REMOVE_AUTO_OPTIMIZE
, and the views
CTX_AUTO_OPTIMIZE_INDEXES
,
CTX_USER_AUTO_OPTIMIZE_INDEXES
and
CTX_AUTO_OPTIMIZE_STATUS
are deprecated.
G.4 CTX_AUTOSYNC_JOBS
The CTX_AUTOSYNC_JOBS
view lists all background synchronization jobs that are owned by the CTXSYS
user.
Column Name | Type | Description |
---|---|---|
|
|
Name of the synchronization job |
|
|
Name of the Oracle Text index |
|
|
Index ID |
|
|
Index owner |
|
|
Partition name |
|
|
Partition ID |
|
|
Original start date of the synchronization job |
|
|
Repeat interval |
|
|
Current state of the job |
|
|
Number of times the synchronization job has run |
Note:
Synchronization jobs are now owned by the CTXSYS
user. You can not use the USER_SCHEDULER_JOBS
view to view the background synchronization jobs for indexes.
G.5 CTX_AUTOSYNC_STATUS
The CTX_AUTOSYNC_STATUS
view lists the status of each run of a background synchronization job that is owned by the CTXSYS
user.
Column Name | Type | Description |
---|---|---|
|
|
Name of the synchronization job |
|
|
Date of the log entry |
|
|
Status of the synchronization job |
|
|
Errors generated by the synchronization job |
Note:
Synchronization jobs are now owned by the CTXSYS
user. You can not use the USER_SCHEDULER_JOBS
view to view the background synchronization jobs for indexes.
G.6 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 |
---|---|---|
|
|
Class name |
|
|
Class description |
G.7 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 |
---|---|---|
|
|
Index owner name |
|
|
Index name |
|
|
Table owner name |
|
|
Table name |
|
|
Column name |
|
|
Column type |
|
|
Section type |
|
|
Section name |
|
|
Section ID |
G.8 CTX_FILTER_CACHE_STATISTICS
This view displays various statistics related to the query filter cache. This view can be queried by all users and it displays the statistics for all indexes.
Column Name | Type | Description |
---|---|---|
|
|
Index owner name |
|
|
Index name |
|
|
Index partition name |
|
|
Current size of the filter cache in bytes |
|
|
Number of queries for which the query results are cached in the filter cache |
|
|
Number of query requests to the filter cache |
|
|
Number of query requests for which matches were found in the filter cache |
Note:
Starting in Oracle Database Release 21c,
CTXFILTERCACHE
is deprecated, and also
CTX_FILTER_CACHE_STATISTICS
and
QUERY_FILTER_CACHE_SIZE
.
G.9 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 |
---|---|---|
|
|
Name of the charset column in base table |
|
|
Number of documents indexed |
|
|
Name of the format column in base table |
|
|
Internal index ID |
|
|
Primary key column(s) |
|
|
Name of the language column in base table |
|
|
Name of index |
|
|
Owner of index |
|
|
Status |
|
|
Interval string required by scheduler job. Only meaningful for |
|
|
Scheduler job name for automatic sync. Only meaningful for |
|
|
Sync memory size. Only meaningful for |
|
|
Degree of parallelism for sync. Only meaningful for the |
|
|
Type of synching: |
|
|
Table name |
|
|
Owner of table |
|
|
Text column name |
|
|
Type of index: |
G.10 CTX_INDEX_ERRORS
This view displays the DML errors and is queryable by CTXSYS
.
Column Name | Type | Description |
---|---|---|
|
|
Index owner |
|
|
Name of index |
|
|
Time of error |
|
|
ROWID of errored document or name of errored operation (for example, |
|
|
Error text |
G.11 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 |
---|---|---|
|
|
Index owner |
|
|
Index name |
|
|
Class name |
|
|
Object name |
G.12 CTX_INDEX_PARTITIONS
This view displays all index partitions. It can be queried by CTXSYS
.
Column Name | Type | Description |
---|---|---|
|
|
Index partition ID |
|
|
Index owner |
|
|
Index name |
|
|
Index partition name |
|
|
Type of synching: |
|
|
Table owner |
|
|
Table name |
|
|
Table partition name |
|
|
Number of documents associated with the partition |
|
|
Partition status |
G.13 CTX_INDEX_SETS
This view displays all index set names. It can be queried by any user.
Column Name | Type | Description |
---|---|---|
|
|
Index set owner |
|
|
Index set name |
G.14 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 |
---|---|---|
|
|
Index set owner |
|
|
Index set name |
|
|
Column list of the sub-index |
|
|
Storage clause of the sub-index |
G.15 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 |
---|---|---|
|
|
Index owner |
|
|
Index name |
|
|
Language of sub-lexer |
|
|
Alternate value of language |
|
|
Name of lexer object used for this language |
G.16 CTX_INDEX_SUB_LEXER_VALUES
Shows the sub-lexer attributes and their values. Accessible by CTXSYS
.
Column Name | Type | Description |
---|---|---|
|
|
Index owner |
|
|
Index name |
|
|
Language of sub-lexer |
|
|
Name of lexer object used for this language |
|
|
Name of sub-lexer attribute |
|
|
Value of attribute of sub-lexer |
G.17 CTX_INDEX_VALUES
This view displays attribute values for each object used in indexes. This view is queryable by CTXSYS
.
Column Name | Type | Description |
---|---|---|
|
|
Index owner |
|
|
Index name |
|
|
Class name |
|
|
Object name |
|
|
Attribute name |
|
|
Attribute value |
G.18 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 |
---|---|---|
|
|
Object class (Datastore, Filter, Lexer, and so on) |
|
|
Object name |
|
|
Object description |
G.19 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 |
---|---|---|
|
|
Object class (Data Store, Filter, Lexer, and so on) |
|
|
Object name |
|
|
Attribute name |
|
|
Description of attribute |
|
|
Required attribute, either Y or N |
|
|
Not currently used |
|
|
Attribute datatype. The value |
|
|
Default value for attribute |
|
|
Minimum value |
|
|
Maximum value |
|
|
Maximum length |
G.20 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 |
---|---|---|
|
|
Class of object |
|
|
Object name |
|
|
Attribute name |
|
|
Attribute value label |
|
|
Attribute value |
|
|
Attribute value description |
G.21 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 |
---|---|---|
|
|
Index owner |
|
|
Index name |
|
|
Table owner |
|
|
Table name |
|
|
Column name |
|
|
Column position |
|
|
Column type |
|
|
Section name |
|
|
Section type |
|
|
Section ID |
|
|
Sort order |
G.22 CTX_PARAMETERS
This view displays all system-defined parameters as defined by CTXSYS
. It can be queried by any user.
Column Name | Type | Description |
---|---|---|
|
|
Parameter name:
|
|
|
Parameter value. For |
G.23 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 |
---|---|---|
|
|
Index owner |
|
|
Name of index |
|
|
Name of partition for local partition indexes. |
|
|
|
|
|
Time of modification |
G.24 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 |
---|---|---|
|
|
Username of preference owner |
|
|
Preference name |
|
|
Preference class |
|
|
Object used |
G.25 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 |
---|---|---|
|
|
Username of preference owner |
|
|
Preference name |
|
|
Attribute name |
|
|
Attribute value |
G.26 CTX_SECTIONS
This view displays information about all the sections, including SDATA and MDATA sections, that have been created in the Text data dictionary. It can be queried by any user.
Column Name | Type | Description |
---|---|---|
|
|
Owner of the section group |
|
|
Name of the section group |
|
|
Type of section, either |
|
|
Section ID |
|
|
Name of section |
|
|
Section tag |
|
|
Y or N visible indicator for field sections only. Y indicator for READ ONLY |
|
|
Shows the datatype name ( |
G.27 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 |
---|---|---|
|
|
Owner of section group |
|
|
Name of section group |
|
|
Type of section group |
G.28 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 |
---|---|---|
|
|
Owner of SQE |
|
|
Name of SQE |
|
|
Query Text |
G.29 CTX_STOPLISTS
This view displays stoplists. Queryable by all users.
Column Name | Type | Description |
---|---|---|
|
|
Owner of stoplist |
|
|
Name of stoplist |
|
|
Number of stopwords |
|
|
Type of stoplist, |
G.30 CTX_STOPWORDS
This view displays the stopwords in each stoplist. Queryable by all users.
Column Name | Type | Description |
---|---|---|
|
|
Stoplist owner |
|
|
Stoplist name |
|
|
Stop type, either |
|
|
Stopword |
|
|
Stopword language |
|
|
Stop pattern |
G.31 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 |
---|---|---|
|
|
Owner of the multi-lexer preference |
|
|
Name of the multi-lexer preference |
|
|
Language of the referenced lexer (full name, not abbreviation) |
|
|
An alternate value for the language |
|
|
Owner of the sub-lexer |
|
|
Name of the sub-lexer |
G.32 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 |
---|---|---|
|
|
Thesaurus owner |
|
|
Thesaurus name |
G.33 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 |
---|---|---|
|
|
Thesaurus name |
|
|
Thesaurus phrase |
|
|
Thesaurus qualifier |
|
|
Thesaurus scope notes |
G.34 CTX_TRACE_VALUES
This view contains one row for each active trace, and shows the current value of each trace.
Column Name | Type | Description |
---|---|---|
|
|
Trace ID |
|
|
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 postinstall steps for patch releases. This may occur when this view is present in the database being patched.
G.35 CTX_USER_ALEXER_DICTS
This view displays all dictionaries created by the current user.
Column Name | Type | Description |
---|---|---|
|
|
Name of the dictionary |
|
|
Language of the dictionary |
G.36 CTX_USER_AUTO_OPTIMIZE_INDEXES
This view displays the user indexes that are registered for auto optimization. It can be queried by all users.
Column Name | Type | Description |
---|---|---|
|
|
Index name |
|
|
Partition name |
Note:
In Oracle Database Release 21c, the procedures
ADD_AUTO_OPTIMIZE
and
REMOVE_AUTO_OPTIMIZE
, and the views
CTX_AUTO_OPTIMIZE_INDEXES
,
CTX_USER_AUTO_OPTIMIZE_INDEXES
and
CTX_AUTO_OPTIMIZE_STATUS
are deprecated.
G.37 CTX_USER_AUTOSYNC_JOBS
The CTX_USER_AUTOSYNC_JOBS
view lists all background synchronization jobs that belong to the indexes in an Oracle Text user's schema.
Column Name | Type | Description |
---|---|---|
|
|
Name of the synchronization job |
|
|
Name of the Oracle Text index |
|
|
Index ID |
|
|
Partition name |
|
|
Partition ID |
|
|
Original start date of the synchronization job |
|
|
Repeat interval |
|
|
Current state of the job |
|
|
Number of times the synchronization job has run |
Note:
Synchronization jobs are now owned by the CTXSYS
user. You can not use the USER_SCHEDULER_JOBS
view to view the background synchronization jobs for indexes.
G.38 CTX_USER_AUTOSYNC_STATUS
The CTX_USER_AUTOSYNC_STATUS
view lists the status of each run of a background synchronization job for indexes in an Oracle Text user's schema.
Column Name | Type | Description |
---|---|---|
|
|
Name of the synchronization job |
|
|
Name of the Oracle Text index |
|
|
Partition name |
|
|
Oracle Text partition name |
|
|
Date of the log entry |
|
|
Status of the synchronization job |
|
|
Errors generated by the synchronization job |
Note:
Synchronization jobs are now owned by the CTXSYS
user. You can not use the USER_SCHEDULER_JOBS
view to view the background synchronization jobs for indexes.
G.39 CTX_USER_EXTRACT_POLICIES
This view displays all of the entity extraction policies owned by the current user. All users can query this view.
Column Name | Type | Description |
---|---|---|
|
|
Entity extraction policy name |
G.40 CTX_USER_EXTRACT_POLICY_VALUES
This view displays all of the values for the entity extraction policies owned by the current user. All users can query this view.
Column Name | Type | Description |
---|---|---|
|
|
Entity extraction policy name |
|
|
Object class |
|
|
Object name |
|
|
Object attribute name |
|
|
Object attribute value |
G.41 CTX_USER_EXTRACT_RULES
This view displays the entity extraction rules for the policies owned by the current user. All users can query this view.
Column Name | Type | Description |
---|---|---|
|
|
Entity extraction policy name |
|
|
Entity extraction rule ID |
|
|
Entity extraction rule language |
|
|
Entity extraction rule contents |
|
|
String mapping backreferences to entity types |
|
|
Entity extraction rule status: compiled, not compiled, to be deleted |
|
|
Comments |
G.42 CTX_USER_EXTRACT_STOP_ENTITIES
This view displays the stop entities owned by the current user. All users can query this view.
Column Name | Type | Description |
---|---|---|
|
|
Entity extraction policy name |
|
|
Stop entity name |
|
|
Stop entity type |
|
|
Entity extraction rule status: compiled, not compiled, to be deleted, subset |
|
|
Comments |
G.43 CTX_USER_EXTRACT_TYPE
The CTX_USER_EXTRACT_TYPE
view displays the entity extraction types for the policies owned by the current user. All users can query this view.
Column Name | Type | Description |
---|---|---|
|
|
Entity extraction policy ID |
|
|
Entity extraction rule ID |
|
|
Entity extraction rule type ID |
|
|
Entity extraction type |
G.44 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 |
---|---|---|
|
|
Index name |
|
|
Table owner name |
|
|
Table name |
|
|
Column name |
|
|
Column type |
|
|
Section type |
|
|
Section name |
|
|
Section ID |
G.45 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 |
---|---|---|
|
|
Name of the charset column of base table |
|
|
Number of documents indexed |
|
|
Name of the format column of base table |
|
|
Internal index ID |
|
|
Primary key column(s) |
|
|
Name of the language column of base table |
|
|
Name of index |
|
|
Status, either |
|
|
This is the interval string required by scheduler job. Only meaningful for |
|
|
This is the scheduler job name for automatic sync. Only meaningful for |
|
|
The sync memory size. Only meaningful for |
|
|
Degree of parallelism for sync. Only meaningful for the |
|
|
Type of synching: |
|
|
Table name |
|
|
Owner of table |
|
|
Text column name |
|
|
Type of index: |
G.46 CTX_USER_INDEX_ERRORS
This view displays the indexing errors for the current user and is queryable by all users.
Column Name | Type | Description |
---|---|---|
|
|
Name of index |
|
|
Time of error |
|
|
|
|
|
Error text |
G.47 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 |
---|---|---|
|
|
Name of index |
|
|
Object name |
|
|
Object description |
G.48 CTX_USER_INDEX_PARTITIONS
This view displays all index partitions for the current user. It is queryable by all users.
Column Name | Type | Description |
---|---|---|
|
|
Number of documents associated with the index partition |
|
|
Index partition ID |
|
|
Index name |
|
|
Index partition name |
|
|
This is the interval string required by scheduler job. Only meaningful for |
|
|
This is the scheduler job name for automatic sync. It is only meaningful for |
|
|
The sync memory size. Only meaningful for |
|
|
Degree of parallelism for sync. Only meaningful for the |
|
|
Type of synching: |
|
|
Partition status |
|
|
Table owner |
|
|
Table name |
|
|
Table partition name |
G.49 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 |
---|---|---|
|
|
Index set name |
G.50 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 |
---|---|---|
|
|
Index set name |
|
|
Column list of the index |
|
|
Storage clause of the index |
G.51 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 |
---|---|---|
|
|
Index name |
|
|
Language of sub-lexer |
|
|
Alternate value of language |
|
|
Name of lexer object used for this language |
G.52 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 |
---|---|---|
|
|
Index name |
|
|
Language of sub-lexer |
|
|
Name of lexer object used for this language |
|
|
Name of sub-lexer attribute |
|
|
Value of sub-lexer attribute |
G.53 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 |
---|---|---|
|
|
Index name |
|
|
Class name |
|
|
Object name |
|
|
Attribute name |
|
|
Attribute value |
G.54 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 |
---|---|---|
|
|
Index name |
|
|
Table owner |
|
|
Table name |
|
|
Column name |
|
|
Column position |
|
|
Column type |
|
|
Section name |
|
|
Section type |
|
|
Section ID |
|
|
Sort order |
G.55 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 |
---|---|---|
|
|
Name of index |
|
|
Name of partition for local partition indexes. |
|
|
Rowid to be indexed |
|
|
Time of modification |
G.56 CTX_USER_PREFERENCES
This view displays all preferences defined by the current user. It can be queried by all users.
Column Name | Type | Description |
---|---|---|
|
|
Preference name |
|
|
Preference class |
|
|
Object used |
G.57 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 |
---|---|---|
|
|
Preference name |
|
|
Attribute name |
|
|
Attribute value |
G.58 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 |
---|---|---|
|
|
Shows the datatype name ( |
|
|
Name of the section group |
|
|
Type of section, either |
|
|
Section ID |
|
|
Name of section |
|
|
Section tag |
|
|
Y or N visible indicator for field sections |
G.59 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 |
---|---|---|
|
|
Name of section group |
|
|
Type of section group |
G.60 CTX_USER_SESSION_SQES
This view displays the definitions of all session-duration SQEs that have been created by the current user.
Column Name | Type | Description |
---|---|---|
|
|
Name of owner of SQE |
|
|
Name of SQE (shared namespace between persistent and session-duration) |
|
|
Query text (max size of 32k) |
G.61 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 |
---|---|---|
|
|
Owner of SQE |
|
|
Name of SQE |
|
|
Query text |
G.62 CTX_USER_STOPLISTS
This view displays stoplists for current user. It is queryable by all users.
Column Name | Type | Description |
---|---|---|
|
|
Name of stoplist |
|
|
Number of stopwords |
|
|
Type of stoplist, |
G.63 CTX_USER_STOPWORDS
This view displays stopwords in each stoplist for current user. Queryable by all users.
Column Name | Type | Description |
---|---|---|
|
|
Stoplist name |
|
|
Stop type, either |
|
|
Stopword |
|
|
Stopword language |
|
|
Stop pattern |
G.64 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 |
---|---|---|
|
|
Name of the multi-lexer preference |
|
|
Language of the referenced lexer (full name, not abbreviation) |
|
|
An alternate value for the language |
|
|
Owner of the sub-lexer |
|
|
Name of the sub-lexer |
G.65 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 |
---|---|---|
|
|
Thesaurus name |
G.66 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 |
---|---|---|
|
|
Thesaurus name |
|
|
Thesaurus phrase |
|
|
Phrase qualifier |
|
|
Scope note of the phrase |
G.67 CTX_VERSION
This view displays the CTXSYS
data dictionary and code version number information.
Column Name | Type | Description |
---|---|---|
|
|
The |
|
|
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. |