Release 2.4
A63820-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 ConText Cartridge Administrator's Guide Release 2.4 A63820-01 |
|
This appendix lists all of the views provided by ConText.
The views are divided into the following three groups:
This section describes the views provided with ConText for monitoring the status of ConText servers.
This view displays all the ConText servers that have been started, including idle servers and inactive servers. Only users assigned the CTXAPP or CTXADMIN roles can query CTX_ALL_SERVERS.
This view displays only ConText servers that are currently active. Only DBA users and users assigned CTXADMIN can query CTX_SERVERS.
This section describes the views provided with ConText for monitoring the status of all the ConText queues.
This view displays a row for each entry in the DML Queue. Only users assigned CTXADMIN can query CTX_ALL_DML_QUEUE.
This view displays the total number of entries in the DML Queue for each policy. Only users assigned CTXADMIN can query CTX_ALL_DML_QUEUE.
This view displays all of the rows (pending and in progress requests) in the DML Queue. Only users assigned CTXADMIN can query CTX_ALL_QUEUE.
This view displays a row for each document for which ConText indexing failed during a DDL or DML operation. Only users assigned CTXADMIN or CTXAPP can query CTX_INDEX_ERRORS.
When the error that caused the indexing for the document to fail is corrected and automatic DML is enabled, once the table that contains the document has been updated, the document is automatically reindexed.
You can also use the CTX_DML.REINDEX procedure to manually reindex the errored document once the error condition has been corrected.
|
Note: Rows in CTX_INDEX_ERRORS are not automatically deleted when the errored documents have been corrected and reindexed. The rows must be manually cleared using CTX_SVC.CLEAR_ERROR. |
This view displays the reindexing status of requests (rows) in the DML Queue. Only users assigned CTXADMIN or CTXAPP can query CTX_INDEX_STATUS.
This view displays all the Linguistics requests that have a status of ERROR. Only users assigned CTXADMIN or CTXAPP can query CTX_LING_ERRORS.
|
Note: Rows in CTX_LING_ERRORS are not automatically deleted when the errored documents have been corrected and reprocessed through the Linguistics. The rows must be manually cleared using CTX_SVC.CLEAR_ERROR. |
This view displays a row for each of the user's entries in the DML Queue. All users can query CTX_INDEX_STATUS.
This view displays the total number of user's entries in the DML Queue for each text column. All users can query CTX_INDEX_STATUS.
| Column Name | Type | Description |
|---|---|---|
|
CID |
NUMBER |
Text column ID |
|
POL_NAME |
VARCHAR2(30) |
Name of policy for text column |
|
CNT |
NUMBER |
Count of rows in DML Queue |
|
TSTAMP |
DATE |
Minimum time stamp for rows |
This view displays all of the rows (pending and in progress requests) in the DML Queue for policies owned by the current user. Only users assigned CTXADMIN or CTXAPP can query CTX_USER_QUEUE.
This view displays a row for each Linguistics request and each reindexing request (DML or DDL) that has a status of ERROR. Only users assigned CTXADMIN or CTXAPP can query CTX_USER_SVCQ.
This section describes the views that can be used to query the Oracle ConText objects in the ConText data dictionary.
This view displays preferences created by ConText users, as well as all the predefined preferences included with ConText. The view contains one row for each preference. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays information about all the sections that have been created in the ConText data dictionary. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays information about all the section groups that have been created in the ConText data dictionary. It can be viewed only by users with the CTXADMIN or CTXAPP role.
| Column Name | Type | Description |
|---|---|---|
|
SGRP_ID |
NUMBER |
Identifier for the section group |
|
SGRP_NAME |
VARCHAR2(30) |
Name of the section group |
|
SGRP_OWNER |
VARCHAR2(30) |
Owner of the section group |
This view displays information about all the thesauri that have been created in the ConText data dictionary. It can be viewed by all ConText users.
| Column Name | Type | Description |
|---|---|---|
|
THS_OWNER |
VARCHAR2(30) |
Username for thesaurus owner |
|
THS_NAME |
VARCHAR2(30) |
Thesaurus name |
This view displays all the preference categories registered in the ConText data dictionary. It can be viewed only by users with the CTXADMIN or CTXAPP role.
| Column Name | Type | Description |
|---|---|---|
|
CLA_ID |
NUMBER(38) |
Category identifier |
|
CLA_NAME |
VARCHAR2(30) |
Category name |
|
CLA_DESC |
VARCHAR2(240) |
Category description |
This view displays all policies that have been assigned to a column (non-template policies). It can be viewed only by users with the CTXADMIN roll.
This view displays all of the details for each indexing operation (index creation, optimization, resumption, etc.) that has been requested. It can be viewed only by users with the CTXADMIN role.
This view displays all of the ConText Tiles registered in the ConText data dictionary. Only users assigned the CTXAPP and CTXADMIN roles can query CTX_OBJECTS. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays the attributes that can be assigned to each Tile. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays the values for the Tile attributes provided by ConText. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays all of the policies created by ConText users, as well as the template policies included with ConText. The view may contain policies with the same name, because a policy must be unique only for the owner. It can be viewed only by users with the CTXADMIN role.
This view displays preferences created by ConText users, as well as all the predefined preferences included with ConText. The view contains one row for each preference. It can be viewed only by users with the CTXADMIN role.
This view displays the attributes assigned to all the preferences in the ConText data dictionary. The view contains one row for each attribute. It can be viewed only by users with the CTXADMIN role.
This view displays the relationship between preferences and policies. The view contains one row for each preference attached to a policy. It can be viewed only by users with the CTXADMIN role.
This view displays all the sources that have been created by ConText users. The view may contain sources with the same name, because a source must be unique only for the owner. It can be viewed by users only with the CTXADMIN role.
This view displays the definitions for all system and session SQEs that have been created by users. It can be viewed only by users with the CTXADMIN role.
This view displays all the system-wide preferences (preferences owned by user CTXSYS) registered in the ConText data dictionary. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays the relationship between system-wide preferences (preferences owned by CTXSYS) and policies. The view contains one row for each preference owned by CTXSYS attached to a policy. It can be viewed only by users with the CTXADMIN or CTXAPP role.
| Column Name | Type | Description |
|---|---|---|
|
POL_ID |
NUMBER |
Policy identifier |
|
POL_NAME |
VARCHAR2(30) |
Policy name |
|
PRE_ID |
NUMBER |
Preference identifier |
|
PRE_NAME |
VARCHAR2(30) |
Preference name |
This view displays all the system-wide template policies (template policies owned by user CTXSYS) registered in the ConText data dictionary. It can be viewed only by users with the CTXADMIN or CTXAPP role.
| Column Name | Type | Description |
|---|---|---|
|
POL_ID |
NUMBER(38) |
Policy identifier |
|
POL_NAME |
VARCHAR2(30) |
Policy name |
|
POL_DESC |
VARCHAR2(240) |
Policy description |
|
POL_OWNER |
VARCHAR2(30) |
Username of policy owner |
This view displays all the template policies registered in the ConText data dictionary. It can be viewed only by users with the CTXADMIN role.
| Column Name | Type | Description |
|---|---|---|
|
POL_ID |
NUMBER(38) |
Policy identifier |
|
POL_NAME |
VARCHAR2(30) |
Policy name |
|
POL_OWNER |
VARCHAR2(30) |
Username of policy owner |
|
POL_DESC |
VARCHAR2(240) |
Policy description |
This view displays all policies that have been assigned to a column (non-template policies) and are owned by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays all of the details for each indexing operation (index creation, optimization, resumption, etc.) that has been requested by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays all policies that are registered in the ConText data dictionary for the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays all preferences defined by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays all the attributes for preferences defined by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays the preferences that are attached to the policies defined for the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays information about the sections that have been created in the ConText data dictionary for the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays information about the section groups that have been created in the ConText data dictionary for the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
| Column Name | Type | Description |
|---|---|---|
|
SGRP_ID |
NUMBER |
Identifier for the section group |
|
SGRP_NAME |
VARCHAR2(30) |
Name of the section group |
This view displays all sources that are registered in the ConText data dictionary for the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays the definitions for all system and session SQEs that have been created by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
This view displays all the template policies defined by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.
| Column Name | Type | Description |
|---|---|---|
|
POL_ID |
NUMBER(38) |
Policy identifier |
|
POL_NAME |
VARCHAR2(30) |
Policy name |
|
POL_DESC |
VARCHAR2(240) |
Policy description |
|
POL_OWNER |
VARCHAR2(30) |
Username of policy owner |
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 ConText users.
| Column Name | Type | Description |
|---|---|---|
|
THS_OWNER |
VARCHAR2(30) |
Username for thesaurus owner |
|
THS_NAME |
VARCHAR2(30) |
Thesaurus name |
