Oracle ConText Option Administrator's Guide, Rel 2.3 Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

ConText Views


This appendix lists all of the views provided by ConText.

The views are divided into the following three groups:

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

 

CHAR2(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_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

 

CHAR2(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_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

 

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_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(38)

 

Policy identifier

 

POL_NAME

 

VARCHAR2(30)

 

Policy name

 

PRE_ID

 

NUMBER(38)

 

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(38)

 

Policy identifier

 

POL_NAME

 

VARCHAR2(30)

 

Policy name

 

PRE_ID

 

NUMBER(38)

 

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

 

VARCHAR2(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_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

 




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index