3.42 ALL_SCHEDULER_FILE_WATCHERS

ALL_SCHEDULER_FILE_WATCHERS displays information about the Scheduler file watch requests accessible to the current user.

Related Views

  • 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(128)

NOT NULL

Owner of the file watch request

FILE_WATCHER_NAME

VARCHAR2(128)

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(128)

Owner of the credential that should be used to authorize the file watch

CREDENTIAL_NAME

VARCHAR2(128)

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