Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SCHEDULER_FILE_WATCHERS

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

Related Views

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