Oracle8i interMedia Text Reference
Release 8.1.5
A67843-01

Library
Product
Contents
Index

Prev Next

H
Views

This appendix lists all of the views provided by interMedia Text.

Overview

The system provides the following views:

CTX_CLASSES

This view displays all the preference categories registered in the Text data dictionary. It can be queried by CTXSYS and users with the CTXAPP role.

Column Name   Type   Description  

CLA_NAME  

VARCHAR2(30)  

Class name  

CLA_DESCRIPTION  

VARCHAR2(80)  

Class description  

CTX_INDEXES

This view displays all indexes that are registered in the Text data dictionary for the current user. It can be queried by CTXSYS.

Column Name   Type   Description  

IDX_ID  

NUMBER  

Internal index id.  

IDX_OWNER  

VARCHAR2(30)  

Owner of index.  

IDX_NAME  

VARCHAR2(30)  

Name of index.  

IDX_TABLE_OWNER  

VARCHAR2(30)  

Owner of table.  

IDX_TABLE  

VARCHAR2(30)  

Table name.  

IDX_KEY_NAME  

VARCHAR2(256)  

Primary key column(s).  

IDX_TEXT_NAME  

VARCHAR2(30)  

Text column name.  

IDX_DOCID_COUNT  

NUMBER  

Number of documents indexed.  

IDX_STATUS  

VARCHAR2(12)  

Status, either INDEXED or INDEXING.  

CTX_INDEX_ERRORS

This view displays the DML errors and is queryable by CTXSYS.

Column Name   Type   Description  

ERR_INDEX_OWNER  

VARCHAR2(30)  

Index owner.  

ERR_INDEX_NAME  

VARCHAR2(30)  

Name of index.  

ERR_TIMESTAMP  

DATE  

Time of error.  

ERR_TEXTKEY  

VARCHAR2(18)  

ROWID of errored document or name of errored operation (ie ALTER INDEX)  

ERR_TEXT  

VARCHAR2(4000)  

Error text.  

CTX_INDEX_OBJECTS

This view displays the objects that are used for each class in the index. It can be queried by CTXSYS.

Column Name   Type   Description  

IXO_INDEX_OWNER  

VARCHAR2(30)  

Index owner.  

IXO_INDEX_NAME  

VARCHAR2(30)  

Index name.  

IXO_CLASS  

VARCHAR2(30)  

Class name.  

IXO_OBJECT  

VARCHAR2(30)  

Object name.  

CTX_INDEX_VALUES

This view displays attribute values for each object used in indexes. This view is queryable by CTXSYS.

Column Name   Type   Description  

IXV_INDEX_OWNER  

VARCHAR2(30)  

Index owner.  

IXV_INDEX_NAME  

VARCHAR2(30)  

Index name.  

IXV_CLASS  

VARCHAR2(30)  

Class name.  

IXV_OBJECT  

VARCHAR2(30)  

Object name.  

IXV_ATTRIBUTE  

VARCHAR2(30)  

Attribute name  

IXV_VALUE  

VARCHAR2(500)  

Attribute value.  

CTX_OBJECTS

This view displays all of the Text objects registered in the Text data dictionary. It can be queried by all users.

Column Name   Type   Description  

OBJ_CLASS  

VARCHAR2(30)  

Object class (Datastore, Filter, Lexer, etc.)  

OBJ_NAME  

VARCHAR2(30)  

Object name  

OBJ_DESCRIPTION  

VARCHAR2(80)  

Object description  

CTX_OBJECT_ATTRIBUTES

This view displays the attributes that can be assigned to preferences of each object. It can be queried by all users.

Column Name   Type   Description  

OAT_CLASS  

VARCHAR2(30)  

Object class (Data Store, Filter, Lexer, etc.)  

OAT_OBJECT  

VARCHAR2(30)  

Object name  

OAT_ATTRIBUTE  

VARCHAR2(64)  

Attribute name  

OAT_DESCRIPTION  

VARCHAR2(80)  

Description of attribute  

OAT_REQUIRED  

VARCHAR2(1)  

Required attribute, either Y or N.  

OAT_STATIC  

VARCHAR2(1)  

Not currently used.  

OAT_DATATYPE  

VARCHAR2(64)  

Attribute datatype  

OAT_DEFAULT  

VARCHAR2(500)  

Default value for attribute  

OAT_MIN  

NUMBER  

Minimum value.  

OAT_MAX  

NUMBER  

Maximum value.  

CTX_OBJECT_ATTRIBUTE_LOV

This view displays the allowed values for certain object attributes provided by interMedia Text. It can be queried by all users.

Column Name   Type   Description  

OAL_CLASS  

NUMBER(38)  

Class of object.  

OAL_OBJECT  

VARCHAR2(30)  

Object name.  

OAL_ATTRIBUTE  

VARCHAR2(32)  

Attribute name.  

OAl_LABEL  

VARCHAR2(30)  

Attribute value label.  

OAL_VALUE  

VARCHAR2(64)  

Attribute value.  

OAL_DESCRIPTION  

VARCHAR2(80)  

Attribute value description.  

CTX_PARAMETERS

This view displays all system-defined parameters as defined by CTXSYS. It can be queried by CTXSYS and users with the CTXAPP role.

Column Name   Type   Description  

PAR_NAME  

VARCHAR2(30)  

Parameter name:

  • max_index_memory

  • default_index_memory

  • default_datastore

  • default_filter_binary

  • default_filter_text

  • default_filter_file

  • default_section_html

  • default_section_text

  • default_lexer

  • default_wordlist

  • default_stoplist

  • default_storage

  • log_directory

 

PAR_VALUE  

VARCHAR2(500)  

Parameter value. For max_index_memory and default_index_memory, PAR_VALUE stores a string consisting of the memory amount. For the other parameter names, PAR_VALUE stores the names of the preferences used as defaults for index creation.  

CTX_PENDING

This view displays a row for each of the user's entries in the DML Queue. It can be queried by CTXSYS.

Column Name   Type   Description  

PND_INDEX_OWNER  

VARCHAR2(30)  

Index owner.  

PND_INDEX_NAME  

VARCHAR2(30)  

Name of index.  

PND_ROWID  

ROWID  

ROWID to be indexed  

PND_TIMESTAMP  

DATE  

Time of modification  

CTX_PREFERENCES

This view displays preferences created by interMedia Text users, as well as all the system-defined preferences included with interMedia Text. The view contains one row for each preference. It can be queried by all users.

Column Name   Type   Description  

PRE_OWNER  

VARCHAR2(30)  

Username of preference owner.  

PRE_NAME  

VARCHAR2(30)  

Preference name.  

PRE_CLASS  

VARCHAR2(30)  

Preference class.  

PRE_OBJECT  

VARCHAR2(30)  

Object used.  

CTX_PREFERENCE_VALUES

This view displays the values assigned to all the preferences in the Text data dictionary. The view contains one row for each value. It can be queried by all users.

Column Name   Type   Description  

PRV_OWNER  

VARCHAR2(30)  

Username of preference owner.  

PRV_PREFERENCE  

VARCHAR2(30)  

Preference name.  

PRV_ATTRIBUTE  

VARCHAR2(64)  

Attribute name  

PRV_VALUE  

VARCHAR2(500)  

Attribute value  

CTX_SECTIONS

This view displays information about all the sections that have been created in the Text data dictionary. It can be queried by users with the CTXSYS and CTXAPP roles.

Column Name   Type   Description  

SEC_OWNER  

VARCHAR2(30)  

Owner of the section group.  

SEC_SECTION_GROUP  

VARCHAR2(30)  

Name of the section group.  

SEC_TYPE  

VARCHAR2(30)  

Type of section, either ZONE, FIELD, or SPECIAL.  

SEC_ID  

NUMBER  

Section id.  

SEC_NAME  

VARCHAR2(30)  

Name of section.  

SEC_TAG  

VARCHAR2(64)  

Section tag  

SEC_VISIBLE  

VARCHAR2(1)  

Y or N visible indicator for field sections only.  

CTX_SECTION_GROUPS

This view displays information about all the section groups that have been created in the Text data dictionary. It can be queried by users with the CTX_SYS role.

Column Name   Type   Description  

SGP_OWNER  

VARCHAR2(30)  

Owner of section group.  

SGP_NAME  

VARCHAR2(30)  

Name of section group.  

SGP_TYPE  

VARCHAR2(30)  

Type of section group  

CTX_SERVERS

This view displays ctxsrv servers that are currently active. It can be queried only by CTXSYS.

Column Name   Type   Description  

SER_NAME  

VARCHAR2(60)  

Server identifier  

SER_STATUS  

VARCHAR2(8)  

Server status (IDLE, RUN, EXIT)  

SER_ADMMBX  

VARCHAR2(60)  

Admin pipe mailbox name for server.  

SER_OOBMBX  

VARCHAR2(60)  

Out-of-band mailbox name for server.  

SER_SESSION  

NUMBER  

No Longer Used  

SER_AUDSID  

NUMBER  

Server audit session ID  

SER_DBID  

NUMBER  

Server database ID  

SER_PROCID  

VARCHAR2(10)  

No Longer Used  

SER_PERSON_MASK  

VARCHAR2(30)  

Personality mask for server  

SER_STARTED_AT  

DATE  

Date on which server was started  

SER_IDLE_TIME  

NUMBER  

Idle time, in seconds, for server  

SER_DB_INSTANCE  

VARCHAR2(10)  

Database instance ID  

SER_MACHINE  

VARCHAR2(64)  

Name of host machine on which server is running  

CTX_SQES

This view displays the definitions for all SQEs that have been created by users. It can be queried by all users.

Column Name   Type   Description  

SQE_OWNER  

VARCHAR2(30)  

Owner of SQE.  

SQE_NAME  

VARCHAR2(30)  

Name of SQE.  

SQE_QUERY  

VARCHAR2(2000)  

Query Text  

CTX_STOPLISTS

This view displays stoplists. Queryable by all users.

Column Name   Type   Description  

SPL_OWNER  

VARCHAR2(30)  

Owner of stoplist.  

SPL_NAME  

VARCHAR2(30)  

Name of stoplist.  

SPL_COUNT  

NUMBER  

Number of stopwords  

CTX_STOPWORDS

This view displays the stopwords in each stoplist. Queryable by all users.

Column Name   Type   Description  

SPW_OWNER  

VARCHAR2(30)  

Stoplist owner.  

SPW_STOPLIST  

VARCHAR2(30)  

Stoplist name.  

SPL_TYPE  

VARCHAR2(10)  

Stop type, either STOP_WORD, STOP_CLASS, STOP_THEME.  

SPW_WORD  

VARCHAR2(80)  

Stopword.  

CTX_THESAURI

This view displays information about all the thesauri that have been created in the Text data dictionary. It can be queried by all interMedia Text users.

Column Name   Type   Description  

THS_OWNER  

VARCHAR2(30)  

Thesaurus owner  

THS_NAME  

VARCHAR2(30)  

Thesaurus name  

CTX_USER_INDEXES

This view displays all indexes that are registered in the Text data dictionary for the current user. It can be queried by all users.

Column Name   Type   Description  

IDX_ID  

NUMBER  

Internal index id.  

IDX_NAME  

VARCHAR2(30)  

Name of index.  

IDX_TABLE_OWNER  

VARCHAR2(30)  

Owner of table.  

IDX_TABLE  

VARCHAR2(30)  

Table name.  

IDX_KEY_NAME  

VARCHAR2(256)  

Primary key column(s).  

IDX_TEXT_NAME  

VARCHAR2(30)  

Text column name.  

IDX_DOCID_COUNT  

NUMBER  

Number of documents indexed.  

IDX_STATUS  

VARCHAR2(12)  

Status, either INDEXED or INDEXING.  

CTX_USER_INDEX_ERRORS

This view displays the DML errors and is queryable by all users.

Column Name   Type   Description  

ERR_INDEX_NAME  

VARCHAR2(30)  

Name of index.  

ERR_TIMESTAMP  

DATE  

Time of error.  

ERR_TEXTKEY  

VARCHAR2(18)  

ROWID of errored document or name of errored operation (ie ALTER INDEX)  

ERR_TEXT  

VARCHAR2(4000)  

Error text.  

CTX_USER_INDEX_OBJECTS

This view displays the preferences that are attached to the indexes defined for the current user. It can be queried by all users.

Column Name   Type   Description  

IXO_INDEX_NAME  

VARCHAR2(30)  

Name of index.  

IXO_CLASS  

VARCHAR2(30)  

Object name  

IXO_OBJECT  

VARCHAR2(80)  

Object description  

CTX_USER_INDEX_VALUES

This view displays attribute values for each object used in indexes. This view is queryable by all users.

Column Name   Type   Description  

IXV_INDEX_NAME  

VARCHAR2(30)  

Index name.  

IXV_CLASS  

VARCHAR2(30)  

Class name.  

IXV_OBJECT  

VARCHAR2(30)  

Object name.  

IXV_ATTRIBUTE  

VARCHAR2(30)  

Attribute name  

IXV_VALUE  

VARCHAR2(500)  

Attribute value.  

CTX_USER_PENDING

This view displays a row for each of the user's entries in the DML Queue. It can be queried by all users.

Column Name   Type   Description  

PND_INDEX_NAME  

VARCHAR2(30)  

Name of index.  

PND_ROWID  

ROWID  

Rowid to be indexed.  

PND_TIMESTAMP  

DATE  

Time of modification.  

CTX_USER_PREFERENCES

This view displays all preferences defined by the current user. It can be queried by all users.

Column Name   Type   Description  

PRE_NAME  

VARCHAR2(30)  

Preference name.  

PRE_CLASS  

VARCHAR2(30)  

Preference class.  

PRE_OBJECT  

VARCHAR2(30)  

Object used.  

CTX_USER_PREFERENCE_VALUES

This view displays all the values for preferences defined by the current user. It can be queried by all users.

Column Name   Type   Description  

PRV_PREFERENCE  

VARCHAR2(30)  

Preference name.  

PRV_ATTRIBUTE  

VARCHAR2(64)  

Attribute name  

PRV_VALUE  

VARCHAR2(500)  

Attribute value  

CTX_USER_SECTIONS

This view displays information about the sections that have been created in the Text data dictionary for the current user. It can be queried by all users.

Column Name   Type   Description  

SEC__SECTION_GROUP  

VARCHAR2(30)  

Name of the section group.  

SEC_TYPE  

VARCHAR2(30)  

Type of section, either ZONE, FIELD, or SPECIAL.  

SEC_ID  

NUMBER  

Section id.  

SEC_NAME  

VARCHAR2(30)  

Name of section.  

SEC_TAG  

VARCHAR2(64)  

Section tag  

SEC_VISIBLE  

VARCHAR2(1)  

Y or N visible indicator for field sections.  

CTX_USER_SECTION_GROUPS

This view displays information about the section groups that have been created in the Text data dictionary for the current user. It can be queried by all users.

Column Name   Type   Description  

SGP_NAME  

VARCHAR2(30)  

Name of section group.  

SGP_TYPE  

VARCHAR2(30)  

Type of section group  

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 by all users.

Column Name   Type   Description  

SQE_OWNER  

VARCHAR2(30)  

Owner of SQE.  

SQE_NAME  

VARCHAR2(30)  

Name of SQE.  

SQE_QUERY  

VARCHAR2(2000)  

Query Text  

CTX_USER_STOPLISTS

This view displays stoplists. It is queryable by all users.

Column Name   Type   Description  

SPL_NAME  

VARCHAR2(30)  

Name of stoplist.  

SPL_COUNT  

NUMBER  

Number of stopwords  

CTX_USER_STOPWORDS

This view displays stopwords in each stoplist. Queryable by all users.

Column Name   Type   Description  

SPW_STOPLIST  

VARCHAR2(30)  

Stoplist name.  

SPW_TYPE  

VARCHAR2(10)  

Stop type, either STOP_WORD, STOP_CLASS, STOP_THEME.  

SPW_WORD  

VARCHAR2(80)  

Stopword.  

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

Column Name   Type   Description  

THS_NAME  

VARCHAR2(30)  

Thesaurus name  


Prev
Next
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index