ALL_SCHEDULER_FILE_WATCHERS displays information about the Scheduler file watch requests accessible to the current user.
DBA_SCHEDULER_FILE_WATCHERS displays information about all Scheduler file watch requests in the database.
USER_SCHEDULER_FILE_WATCHERS displays information about the Scheduler file watch requests owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the file watch request |
FILE_WATCHER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the file watch request |
ENABLED |
VARCHAR2(5) |
Indicates whether this file watch request is enabled (TRUE) or disabled (FALSE) |
|
DESTINATION_OWNER |
VARCHAR2(128) |
Owner of the named destination object | |
DESTINATION |
VARCHAR2(128) |
Name of the destination object | |
DIRECTORY_PATH |
VARCHAR2(4000) |
NOT NULL |
Name of the directory path where the file will arrive |
FILE_NAME |
VARCHAR2(512) |
NOT NULL |
Name or pattern specifying the files that need to be monitored |
CREDENTIAL_OWNER |
VARCHAR2(30) |
Owner of the credential that should be used to authorize the file watch | |
CREDENTIAL_NAME |
VARCHAR2(30) |
Name of the credential that should be used to authorize the file watch | |
MIN_FILE_SIZE |
NUMBER |
NOT NULL |
Minimum size of the file being monitored |
STEADY_STATE_DURATION |
INTERVAL DAY(3) TO SECOND(0) |
Time to wait before concluding that the file has stopped growing | |
LAST_MODIFIED_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Time at which this file watcher was last modified | |
COMMENTS |
VARCHAR2(240) |
Comments on the file watch request |