Oracle® Ultra Search Administrator's Guide
10g Release 2 (10.1.2) Part No. B14041-01 |
|
Previous |
Next |
This appendix lists all of the views provided by Oracle Ultra Search. The system provides the following views:
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
|
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 |