This appendix lists all the views provided by Oracle Ultra Search. The system provides the following views:
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 |
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 |
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 |