Oracle Context Option Administrator's Guide

Library

Product

Contents

Index

APPENDIX B. ConText Data Dictionary Views

CTXADMIN Views
CTXAPP Views
CTXUSER Views

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

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

CTXADMIN Views

CTXAPP Views

CTXUSER Views

CTXADMIN Views

This section describes the views that can be used by CTXADMIN 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) Status of current run

CTX_POLICIES

This view displays all of the policies created by ConText Option users, as well as the template policies included with ConText Option. 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.

CTX_PREFERENCES

This view displays preferences created by ConText Option users and predefined preferences included with ConText Option. 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 Option 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) Pref. 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 pref. category (Y or N)
OBJ_ID NUMBER(38) Tile identifier
CLA_ID NUMBER(38) Pref. 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) Pref. category for Tile (Data Store, Filter, Lexer, etc.)
CLA_ID NUMBER(38) Pref. 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 (255 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 Option.

Column Name Type Description
CLA_ID NUMBER(38) Pref. category identifier
CLA_NAME VARCHAR2(30) Pref. 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 (policies owned by user CTXSYS) registered in the ConText data dictionary.

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) Status of current run

CTX_USER_POLICIES

This view displays all policies that are registered in the ConText data dictionary for the 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 Null? Type Description
PRE_ID NOT NULL NUMBER(38) Preference identifier
PRE_NAME VARCHAR2(30) Preference name
PRE_DESC VARCHAR2(240) Preference description
PRE_OBJ_NAME NOT NULL VARCHAR2(30) Tile specified in preference
PRE_CLA_NAME NOT NULL VARCHAR2(30) Category for Tile
PRE_OBJ_ID NOT NULL NUMBER(38) Identifier for Tile in preference
PRE_CLA_ID NOT NULL NUMBER(38) Identifier for category of preference
PRE_OWNER VARCHAR2(30) Username for preference owner

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.

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.