Oracle8 ConText Cartridge Administrator's Guide Release 2.3 A58165-01 |
Library | Product | Contents | Index

# B
ConText Views

This appendix lists all of the views provided by ConText.

The views are divided into the following three groups:

- ConText Server Views
- ConText Queue Views
- ConText Data Dictionary Views

## ConText Server Views

This section describes the views provided with ConText for monitoring the status of ConText servers.

### CTX_ALL_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.

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

### CTX_SERVERS

This view displays only ConText servers that are currently active. Only DBA users and users assigned CTXADMIN can query CTX_SERVERS.

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

## ConText Queue Views

This section describes the views provided with ConText for monitoring the status of all the ConText queues.

### CTX_ALL_DML_QUEUE

This view displays a row for each entry in the DML Queue. Only users assigned CTXADMIN can query CTX_ALL_DML_QUEUE.

Column Name | Type | Description
--- | --- | ---
CID | NUMBER | Text column ID
POL_OWNER | VARCHAR2(30) | Owner of policy for text column
POL_NAME | VARCHAR2(30) | Name of policy for text column
SID | VARCHAR2(10) | Identifier for ConText server working on row (value is PENDING if a ConText server is not yet assigned)
PKEY | VARCHAR2(256) | Primary key of row being processed
TIME | DATE | Lower bound of time row was last updated

### CTX_ALL_DML_SUM

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.

Column Name | Type | Description
--- | --- | ---
CID | NUMBER | Text column ID
POL_OWNER | VARCHAR2(30) | Owner of policy for text column
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

### CTX_ALL_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.

Column Name | Type | Description
--- | --- | ---
CID | NUMBER | Policy ID
SID | VARCHAR2(10) | ID (name) of server processing the request (if the request is pending, this column is NULL)
PKEY | VARCHAR2(256) | Textkey (primary key) of column policy
TIME | DATE | Lower boundary of time row was last updated
BATCH | NUMBER | ID of batch in which request is being processed (used for batch DML)

### CTX_INDEX_ERRORS

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.

Column Name | Type | Description
--- | --- | ---
HANDLE | NUMBER | Handle ID for errored document
TSTAMP | DATE | Time stamp
POL_OWNER | VARCHAR2(30) | Username of Policy owner for text column in which errored document is stored
POL_NAME | VARCHAR2(30) | Name of Policy for text column in which errored document is stored
PK | VARCHAR2(64) | Textkey for errored document
ERRORS | VARCHAR2(2000) | Error text for errored document

### CTX_INDEX_STATUS

This view displays the reindexing status of requests (rows) in the DML Queue. Only users assigned CTXADMIN or CTXAPP can query CTX_INDEX_STATUS.

Column Name | Type | Description
--- | --- | ---
STATUS | VARCHAR2(1) | Status of DML request
POL_OWNER | VARCHAR2(30) | Username of policy owner for DML request
POL_NAME | VARCHAR2(30) | Name of policy for DML request
PK | VARCHAR2(256) | ID for the document being processed by the DML request

### CTX_LING_ERRORS

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.

Column Name | Type | Description
--- | --- | ---
HANDLE | NUMBER | Handle ID
TSTAMP | DATE | Time stamp
POL_OWNER | VARCHAR2(2000) | Policy owner for column in which document with errored request is stored
POL_NAME | VARCHAR2(2000) | Policy name for column in which document with errored request is stored
PK | VARCHAR2(64) | Textkey for document with errored request
ERRORS | VARCHAR2(2000) | Error text for errored request

### CTX_USER_DML_QUEUE

This view displays a row for each of the user's entries in the DML Queue. 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
SID | VARCHAR2(10) | Identifier for ConText server working on row (value is PENDING if a ConText server is not yet assigned)
PKEY | VARCHAR2(256) | Primary key of row being processed
TIME | DATE | Lower bound of time row was last updated

### CTX_USER_DML_SUM

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

### CTX_USER_QUEUE

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.

Column Name | Type | Description
--- | --- | ---
CID | NUMBER | Policy ID
SID | VARCHAR2(10) | ID (name) of server processing the request (if the request is pending, this column is NULL)
PKEY | VARCHAR2(256) | Textkey (primary key) of column policy
TIME | DATE | Lower boundary of time row was last updated
BATCH | NUMBER | ID of batch in which request is being processed (for batch DML)

### CTX_USER_SVCQ

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.

Column Name | Type | Description
--- | --- | ---
SVCNO | NUMBER | Services Queue number
STATUS | VARCHCHAR2(1) | Request status
SID | NUMBER | Identifier of server that processed request
SERVICE | NUMBER | Requested service
PRIORITY | NUMBER | Priority of request
TSTAMP | DATE | Lower boundary of time row was last updated
USERNAME | VARCHAR2(30) | Policy owner who submitted request
PAR1-10 | VARCHAR2(2000) | Parameters (internal use only)
ERRORS | VARCHAR2(2000) | Error text

## ConText Data Dictionary Views

This section describes the views that can be used to query the Oracle ConText objects in the ConText data dictionary.

### CTX_ALL_PREFERENCES

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.

Column Name | Type | Description
--- | --- | ---
PRE_ID | NUMBER | Preference identifier
PRE_NAME | VARCHAR2(30) | Preference name
PRE_DESC | VARCHAR2(240) | Preference description
PRE_OBJ_NAME | VARCHAR2(30) | Tile specified in preference
PRE_CLA_NAME | VARCHAR2(30) | Category for Tile
PRE_OBJ_ID | NUMBER | Identifier for Tile in preference
PRE_CLA_ID | NUMBER | Identifier for category of preference
PRE_OWNER | VARCHAR2(30) | Username of preference owner

### CTX_ALL_SECTIONS

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.

Column Name | Type | Description
--- | --- | ---
SEC_ID | NUMBER | Identifier for the section
SEC_NAME | VARCHAR2(30) | Name of the section
SGRP_ID | NUMBER | Identifier for the section group to which the section belongs
SGRP_NAME | VARCHAR2(30) | Name of the section group to which the section belongs
SGRP_OWNER | VARCHAR2(30) | Owner of the section group to which the section belongs
START_TAG | VARCHAR2(64) | String of characters that identify the start of the section
END_TAG | VARCHAR2(64) | String of characters that identify the end of the section
TOP_LEVEL | CHAR(1) | Indicates whether the section is a top-level section
ENCLOSE_SELF | CHAR(1) | Indicates whether the section is self-enclosing

### CTX_ALL_SECTION_GROUPS

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

### CTX_ALL_THESAURI

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

### CTX_CLASS

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

### CTX_COLUMN_POLICIES

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.

Column Name | Type | Description
--- | --- | ---
POL_ID | NUMBER(38) | Policy identifier
POL_NAME | VARCHAR2(30) | Policy name
POL_DESC | VARCHAR2(240) | Policy description
POL_TABLENAME | VARCHAR2(30) | Name of table to which policy is attached
POL_OWNER | VARCHAR2(30) | Username of policy owner
POL_KEY_NAME | VARCHAR2(256) | Name of textkey column in table containing text column
POL_LN_NAME | VARCHAR2(60) | Name of line number column in table containing text column (only used when master/ detail data store used)
POL_TEXT_EXPR | VARCHAR2(2000) | Name of text column
POL_STATUS | VARCHAR2(12) | Status of policy (VALID or INVALID)

### CTX_INDEX_LOG

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.

Column Name | Type | Description
--- | --- | ---
TXIL_POL_ID | NUMBER | Policy identifier
TXIL_OPERATION | VARCHAR2(1) | Code which identifies the index operation performed for the policy
TXIL_OPER_STAGE | VARCHAR2(1) | Code which identifies the current stage of the indexing operation
TXIL_RUN_SEQ | NUMBER | Identifier for run in which the index operation was processed
TXIL_SERVER_ID | NUMBER | Identifier for ConText server processing the indexing request
TXIL_START_TIME | DATE | Time and date the index operation was started
TXIL_FIRST_DOC | VARCHAR2(256) | Textkey for first document processed
TXIL_DOC_ SELECTED_CNT | NUMBER | Number of documents selected for processing
TXIL_LAST_DOC | VARCHAR2(256) | Textkey for last document processed
TXIL_DOC_ PROCESSED_CNT | NUMBER | Number of documents processed
TXIL_MID_ FLUSH_FLAG | VARCHAR2(1) | Flag indicating whether a halted index operation is resumed or started over
TXIL_END_TIME | DATE | Time and date the index operation ended
TXIL_CURR_RUN | VARCHAR2(1) | Identifier for current run (internal use only)

### CTX_OBJECTS

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.

Column Name | Type | Description
--- | --- | ---
OBJ_NAME | VARCHAR2(30) | Tile name
CLA_NAME | VARCHAR2(30) | Preference category for Tile (Data Store, Filter, Lexer, etc.)
OBJ_DESC | VARCHAR2(240) | Tile description
OBJ_VALIDATE_ PROC | VARCHAR2(240) | Procedure to call to validate preference settings for Tile
OBJ_IS_ DEFAULT | VARCHAR2(1) | Default Tile for the preference category (Y or N)
OBJ_ID | NUMBER(38) | Tile identifier
CLA_ID | NUMBER(38) | Preference category identifier for Tile

### CTX_OBJECT_ATTRIBUTES

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.

Column Name | Type | Description
--- | --- | ---
CLA_NAME | VARCHAR2(30) | Preference category for Tile (Data Store, Filter, Lexer, etc.)
CLA_ID | NUMBER(38) | Preference category identifier for Tile
OBJ_NAME | VARCHAR2(30) | Tile name
OBJ_ID | NUMBER(38) | Tile identifier
OAT_NAME | VARCHAR2(64) | Attribute name
OAT_ORDINAL | NUMBER(4) | Order number for attribute
OAT_DATATYPE | VARCHAR2(64) | Attribute datatype
OAT_OPTIONAL | VARCHAR2(2) | Attribute optional (Y or N)
OAT_CARDINALITY | NUMBER | Number of times attribute can be specified in the same preference (4095 for STOP_WORD attribute, 1 for all other attributes)
OAT_DEFAULT_VAL | VARCHAR2(1000) | Default value for attribute
OAT_DESCRIPTION | VARCHAR2(1000) | Description of attribute

### CTX_OBJECT_ATTRIBUTES_LOV

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.

Column Name | Type | Description
--- | --- | ---
CLA_ID | NUMBER(38) | Preference category identifier
CLA_NAME | VARCHAR2(30) | Preference category for Tile
OBJ_ID | NUMBER(38) | Tile identifier
OBJ_NAME | VARCHAR2(30) | Tile name
OAT_NAME | VARCHAR2(64) | Attribute name
OAL_VALUE | VARCHAR2(64) | Attribute value
OAL_DESCRIPTION | VARCHAR2(64) | Attribute value description

### CTX_POLICIES

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.

Column Name | Type | Description
--- | --- | ---
POL_ID | NUMBER(38) | Policy identifier
POL_NAME | VARCHAR2(30) | Policy name
POL_DESC | VARCHAR2(240) | Policy description
POL_TABLENAME | VARCHAR2(30) | Name of table to which policy is attached
POL_OWNER | VARCHAR2(30) | Username of policy owner
POL_KEY_NAME | VARCHAR2(256) | Name of textkey column in table containing text column
POL_LN_NAME | VARCHAR2(60) | Name of line number column in table containing text column (only used when master/ detail data store used)
POL_TEXT_EXPR | VARCHAR2(2000) | Name of text column
POL_STATUS | VARCHAR2(12) | Status of policy (VALID or INVALID)

### CTX_PREFERENCES

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.

Column Name | Type | Description
--- | --- | ---
PRE_ID | NUMBER(38) | Preference identifier
PRE_NAME | VARCHAR2(30) | Preference name
PRE_OWNER | VARCHAR2(30) | Username of preference owner
PRE_DESC | VARCHAR2(240) | Preference description
PRE_OBJ_NAME | VARCHAR2(30) | Tile specified in preference
PRE_CLA_NAME | VARCHAR2(30) | Category for Tile
PRE_OBJ_ID | NUMBER(38) | Identifier for Tile in preference
PRE_CLA_ID | NUMBER(38) | Identifier for category of preference

### CTX_PREFERENCE_ATTRIBUTES

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.

Column Name | Type | Description
--- | --- | ---
PRE_OWNER | VARCHAR2(30) | Username of preference owner
PRE_NAME | VARCHAR2(30) | Preference name
ATT_NAME | VARCHAR2(64) | Name of Tile attribute specified in preference
ATT_VALUE | VARCHAR2(1000) | Value of Tile attribute
ATT_SEQ | NUMBER(38) | Sequence assigned to Tile attribute
ATT_PRE_ID | NUMBER(38) | Identifier for preference
ATT_DESC | VARCHAR2(1000) | Attribute description
ATT_TYPE | VARCHAR2(64) | Attribute type

### CTX_PREFERENCE_USAGE

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.

Column Name | Type | Description
--- | --- | ---
POL_TYPE | VARCHAR2(6) | Policy type
POL_ID | NUMBER(38) | Policy identifier
POL_OWNER | VARCHAR2(30) | Username of policy owner
POL_NAME | VARCHAR2(30) | Policy name
PRE_ID | NUMBER(38) | Preference identifier
PRE_OWNER | VARCHAR2(30) | Username of preference owner
PRE_NAME | VARCHAR2(30) | Preference name

### CTX_SOURCE

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.

Name | Null? | Type
--- | --- | ---
SRC_ID | NUMBER(38) | Source identifier
SRC_NAME | VARCHAR2(30) | Source name
SRC_DESC | VARCHAR2(240) | Source description
SRC_OWNER | VARCHAR2(30) | Username of source owner
SRC_CREATED_BY | VARCHAR2(30) | Username of user who created source
SRC_REFRESH | NUMBER | Refresh rate, in minutes, before a ConText server with the Reader personality checks for new files to be loaded.
SRC_NEXT | DATE | Date and time of the next load (calculated using SYSDATE of last load plus refresh rate
SRC_SID | NUMBER | Identifier for ConText server processing the source, NULL if no ConText servers are currently processing the source
SRC_CURRENT | VARCHAR2(2000) | Not currently used
SRC_TABLE_NAME | VARCHAR2(30) | Name of the table for the source
SRC_COLUMN_NAME | VARCHAR2(30) | Name of the text column for the source

### CTX_SQES

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.

Column Name | Type | Description
--- | --- | ---
POL_NAME | VARCHAR2(30) | Policy name for SQE
POL_OWNER | VARCHAR2(30) | Username of policy owner for SQE
POL_ID | NUMBER(38) | Policy identifier for SQE
QUERY_NAME | VARCHAR2(32) | Name of SQE
SESSION_ID | VARCHAR2(32) | Session identifier for SQE ('SYSTEM' for System SQEs)
QUERY_TEXT | VARCHAR2(2000) | Query expression for SQE
TSTAMP | DATE | Date and time SQE was created or last updated

### CTX_SYSTEM_PREFERENCES

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.

Column Name | Type | Description
--- | --- | ---
PRE_ID | NUMBER(38) | Preference identifier
PRE_NAME | VARCHAR2(30) | Preference name
PRE_DESC | VARCHAR2(240) | Preference description
PRE_OBJ_NAME | VARCHAR2(30) | Tile specified in preference
PRE_CLA_NAME | VARCHAR2(30) | Category for Tile
PRE_OBJ_ID | NUMBER(38) | Identifier for Tile in preference
PRE_CLA_ID | NUMBER(38) | Identifier for category of preference
PRE_OWNER | VARCHAR2(30) | Username for preference owner

### CTX_SYSTEM_PREFERENCE_USAGE

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

### CTX_SYSTEM_TEMPLATE_POLICIES

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

### CTX_TEMPLATE_POLICIES

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

### CTX_USER_COLUMN_POLICIES

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.

Column Name | Type | Description
--- | --- | ---
POL_ID | NUMBER(38) | Policy identifier
POL_NAME | VARCHAR2(30) | Policy name
POL_DESC | VARCHAR2(240) | Policy description
POL_TABLENAME | VARCHAR2(30) | Name of table to which policy is attached
POL_KEY_NAME | VARCHAR2(256) | Name of textkey column in table containing text column
POL_LN_NAME | VARCHAR2(60) | Name of line number column in table containing text column (only used when master/ detail data store used)
POL_TEXT_EXPR | VARCHAR2(2000) | Name of text column
POL_STATUS | VARCHAR2(12) | Status of policy (VALID or INVALID)

### CTX_USER_INDEX_LOG

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.

Column Name | Type | Description
--- | --- | ---
TXIL_POL_ID | NUMBER | Policy identifier
TXIL_OPERATION | VARCHAR2(1) | Code which identifies the index operation performed for the policy
TXIL_OPER_STAGE | VARCHAR2(1) | Code which identifies the current stage of the indexing operation
TXIL_RUN_SEQ | NUMBER | Identifier for run in which the indexing operation was processed
TXIL_SERVER_ID | NUMBER | Identifier for ConText server processing the indexing request
TXIL_START_TIME | DATE | Time and date the index operation was started
TXIL_FIRST_DOC | VARCHAR2(256) | Textkey for first document processed
TXIL_DOC_ SELECTED_CNT | NUMBER | Number of documents selected for processing
TXIL_LAST_DOC | VARCHAR2(256) | Textkey for last document processed
TXIL_DOC_ PROCESSED_CNT | NUMBER | Number of documents processed
TXIL_MID_ FLUSH_FLAG | VARCHAR2(1) | Flag indicating whether a halted index operation is resumed or started over
TXIL_END_TIME | DATE | Time and date the index operation ended
TXIL_CURR_RUN | VARCHAR2(1) | Identifier for current run (internal use only)

### CTX_USER_POLICIES

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.

Column Name | Type | Description
--- | --- | ---
POL_ID | NUMBER(38) | Policy identifier
POL_NAME | VARCHAR2(30) | Policy name
POL_DESC | VARCHAR2(240) | Policy description
POL_TABLENAME | VARCHAR2(30) | Name of table to which policy is attached
POL_KEY_NAME | VARCHAR2(256) | Name of textkey column in table containing text column
POL_LN_NAME | VARCHAR2(60) | Name of line number column in table containing text column (only used when master/ detail data store used)
POL_TEXT_EXPR | VARCHAR2(2000) | Name of text column
POL_STATUS | VARCHAR2(12) | Status of policy (VALID or INVALID)

### CTX_USER_PREFERENCES

This view displays all preferences defined by the current user. It can be viewed only by users with the CTXADMIN or CTXAPP role.

Column Name | Type | Description
--- | --- | ---
PRE_ID | NUMBER(38) | Preference identifier
PRE_NAME | VARCHAR2(30) | Preference name
PRE_DESC | VARCHAR2(240) | Preference description
PRE_OBJ_NAME | VARCHAR2(30) | Tile specified in preference
PRE_CLA_NAME | VARCHAR2(30) | Category for Tile
PRE_OBJ_ID | NUMBER(38) | Identifier for Tile in preference
PRE_CLA_ID | NUMBER(38) | Identifier for category of preference
PRE_OWNER | VARCHAR2(30) | Username for preference owner

### CTX_USER_PREFERENCE_ATTRIBUTES

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.

Column Name | Type | Description
--- | --- | ---
PRE_OWNER | VARCHAR2(30) | Username of preference owner
PRE_NAME | VARCHAR2(30) | Preference name
ATT_NAME | VARCHAR2(64) | Name of Tile attribute specified in preference
ATT_VALUE | VARCHAR2(1000) | Value of Tile attribute
ATT_SEQ | NUMBER(38) | Sequence assigned to Tile attribute
ATT_PRE_ID | NUMBER(38) | Identifier for preference
ATT_DESC | VARCHAR2(1000) | Attribute description
ATT_TYPE | VARCHAR2(64) | Attribute type

### CTX_USER_PREFERENCE_USAGE

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.

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
PRE_OWNER | VARCHAR2(30) | Username of preference owner

### CTX_USER_SECTIONS

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.

Column Name | Type | Description
--- | --- | ---
SEC_ID | NUMBER | Identifier for section
SEC_NAME | VARCHAR2(30) | Name of section
SGRP_ID | NUMBER | Identifier for section group to which the section belongs
SGRP_NAME | VARCHAR2(30) | Name of the section group to which the section belongs
START_TAG | VARCHAR2(64) | String of characters that identify the start of the section
END_TAG | VARCHAR2(64) | String of characters that identify the end of the section
TOP_LEVEL | CHAR(1) | Indicates whether the section is a top-level section
ENCLOSE_SELF | CHAR(1) | Indicates whether the section is self-enclosing

### CTX_USER_SECTION_GROUPS

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

### CTX_USER_SOURCES

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.

Name | Null? | Type
--- | --- | ---
SRC_ID | NUMBER(38) | Source identifier
SRC_NAME | VARCHAR2(30) | Source name
SRC_DESC | VARCHAR2(240) | Source description
SRC_OWNER | VARCHAR2(30) | Username of source owner
SRC_CREATED_BY | VARCHAR2(30) | Username of user who created source
SRC_REFRESH | NUMBER | Refresh rate, in minutes, before a ConText server with the Reader personality checks for new files to be loaded.
SRC_NEXT | DATE | Date and time of the next load (calculated using SYSDATE of last load plus refresh rate
SRC_SID | NUMBER | Identifier for ConText server processing the source, NULL if no ConText servers are currently processing the source
SRC_CURRENT | VARCHAR2(2000) | Not currently used
SRC_TABLE_NAME | VARCHAR2(30) | Name of the table for the source
SRC_COLUMN_NAME | VARCHAR2(30) | Name of the text column for the source

### 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 only by users with the CTXADMIN or CTXAPP role.

Column Name | Type | Description
--- | --- | ---
POL_NAME | VARCHAR2(30) | Policy name for SQE
POL_OWNER | VARCHAR2(30) | Username of policy owner for SQE
POL_ID | NUMBER | Policy identifier for SQE
QUERY_NAME | VARCHAR2(32) | Name of SQE
SESSION_ID | VARCHAR2(32) | Session identifier for SQE ('SYSTEM' for System SQEs)
QUERY_TEXT | VARCHAR2(2000) | Query expression for SQE
TSTAMP | DATE | Date and time SQE was created or last updated

### CTX_USER_TEMPLATE_POLICIES

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

### 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 ConText users.

Column Name | Type | Description
--- | --- | ---
THS_OWNER | VARCHAR2(30) | Username for thesaurus owner
THS_NAME | VARCHAR2(30) | Thesaurus name

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index