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

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

No Longer Used

SER_AUDSID

NUMBER

ConText server audit session ID

SER_DBID

NUMBER

ConText server database ID

SER_PROCID

VARCHAR2(10)

No Longer Used

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

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	No Longer Used
SER_AUDSID	NUMBER	ConText server audit session ID
SER_DBID	NUMBER	ConText server database ID
SER_PROCID	VARCHAR2(10)	No Longer Used
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	No Longer Used
SER_AUDSID	NUMBER	ConText server audit session ID
SER_DBID	NUMBER	ConText server database ID
SER_PROCID	VARCHAR2(10)	No Longer Used
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

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)

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

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

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

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

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

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

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

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

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

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

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

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)

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)

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

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

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

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.

CTX_PREFERENCES

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.

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.

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.

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.

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.