Skip Headers
Oracle® Ultra Search Administrator's Guide
10g Release 2 (10.2)

Part Number B14222-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

C Oracle Ultra Search Views

This appendix lists all the views provided by Oracle Ultra Search. The system provides the following views:

OUS_INSTANCES

This view displays all instance information.

Column Name Type Description
INS_ID NUMBER Instance ID
INS_NAME VARCHAR2(100) Instance name
INS_SCHEMA VARCHAR2(30) Instance owner
INS_MODE ONLY VARCHAR2(30) Instance mode; UPDATABLE/READ

OUS_SCHEDULES

This view displays schedule data for the current instance.

Column Name Type Description
SCH_ID NUMBER Schedule ID
SCH_NAME VARCHAR2(100) Schedule name
SCH_INTERVAL VARCHAR2(30) Schedule interval
SCH_LAST_RUN DATE Time stamp of last run
SCH_NEXT DATE Next scheduled run
SCH_STATUS VARCHAR2(100) Schedule status
SCH_ERROR VARCHAR2(4000) Schedule error if failed
SCH_CRAWLER_LOG_NAME VARCHAR2(100) Log file name of current running crawler
SCH_CRAWLER_ID NUMBER ID of the crawler to run this schedule
SCH_FORCE_RECRAWL NUMBER Force recrawl of the data source
SCH_CRAWL_HOME VARCHAR2(30) Schedule crawling mode

OUS_DEFAULT_CRAWLER_SETTINGS

This view shows default crawler settings like crawling depth and log file directory.

Column Name Type Description
DCS_NAME VARCHAR2(30) Crawler setting name
DCS_VALUE VARCHAR2(4000) Crawler setting value

OUS_CRAWLER_SETTINGS

This view shows crawler setting at the data source level for the current instance.

Column Name Type Description
CWS_DS_ID NUMBER Data source ID
CWS_NAME VARCHAR2(30) Crawler setting name
CWS_VALUE VARCHAR2(4000) Crawler setting value