Skip Headers
Oracle® Ultra Search Administrator's Guide
10g Release 2 (10.1.2)
Part No. B14041-01
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

C Oracle Ultra Search Views

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

OUS_INSTANCES

This view displays all instance information. Any user can query it.

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