B
ConText Data Dictionary Views

This appendix contains schema information about the ConText data dictionary views provided with ConText.

The views are divided into the following three groups, based on the ConText roles that are granted access to the views:

CTXADMIN Views

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

CTX_COLUMN_POLICIES

This view displays all policies that have been assigned to a column (non-template policies).

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.

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_POLICIES

This view displays all of the policies created by ConText users, as well as the template policies included with ConText. The view contains one row for each policy. The view may contain policies with the same name, because a policy must be unique only for a particular user (owner). Different users can have policies with the same name.

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 and predefined preferences included with ConText. The view contains one row for each preference.

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.

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.

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_SQES

This view displays the definitions for all system and session SQEs that have been created by users.

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_TEMPLATE_POLICIES

This view displays all the template policies registered in the ConText data dictionary.

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

CTXAPP Views

This section describes the views that can be used by CTXADMIN and CTXAPP users to query the Oracle ConText objects in the ConText data dictionary.

CTX_CLASS

This view displays all the preference categories registered in the ConText data dictionary.

Column Name	Type	Description
CLA_ID	NUMBER(38)	Category identifier
CLA_NAME	VARCHAR2(30)	Category name
CLA_DESC	VARCHAR2(240)	Category description

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.

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.

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.

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_SYSTEM_PREFERENCES

This view displays all the system-wide preferences (preferences owned by user CTXSYS) registered in the ConText data dictionary.

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.

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.

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_COLUMN_POLICIES

This view displays all policies that have been assigned to a column (non-template policies) and are owned by the current user.

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.

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.

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.

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.

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.

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_SQES

This view displays the definitions for all system and session SQEs that have been created by the current user.

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.

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

CTXUSER Views

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

CTX_ALL_THESAURI

This view displays information about all the thesauri that have been created in the system.

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

CTX_USER_THESAURI

This view displays the information about all of the thesauri that have been created in the system by the current user.

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

B ConText Data Dictionary Views