DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_SCHEDULER_FILE_WATCHERS

Object Details
Object Name: USER_SCHEDULER_FILE_WATCHERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Scheduler file watch requests owned by the current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE_WATCHER_NAME VARCHAR2 (128) Yes Name of file watch request
ENABLED VARCHAR2 (5)
Is this file watch request enabled
DESTINATION_OWNER VARCHAR2 (128)
Owner of named destination object
DESTINATION VARCHAR2 (128)
Name of destination object
DIRECTORY_PATH VARCHAR2 (4000) Yes Pathname of directory where file will arrive
FILE_NAME VARCHAR2 (512) Yes Name or pattern specifying the files that need to be monitored
CREDENTIAL_OWNER VARCHAR2 (128)
Owner of credential that should be used to authorize file watch
CREDENTIAL_NAME VARCHAR2 (128)
Name of credential that should be used to authorize file watch
MIN_FILE_SIZE NUMBER
Yes Minimum size of file being monitored
STEADY_STATE_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
Time to wait before concluding that the file has stopped growing
LAST_MODIFIED_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Time at which this file watcher was last modified
COMMENTS VARCHAR2 (240)
Comments on the file watch request
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE_WATCHER_NAME
,      ENABLED
,      DESTINATION_OWNER
,      DESTINATION
,      DIRECTORY_PATH
,      FILE_NAME
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      MIN_FILE_SIZE
,      STEADY_STATE_DURATION
,      LAST_MODIFIED_TIME
,      COMMENTS
FROM SYS.USER_SCHEDULER_FILE_WATCHERS;

Dependencies

[top of page]

SYS.USER_SCHEDULER_FILE_WATCHERS references the following:

SchemaSYS
TableOBJ$
TableSCHEDULER$_FILE_WATCHER
TableUSER$
SYS.USER_SCHEDULER_FILE_WATCHERS is referenced by following:

SchemaPUBLIC
SynonymUSER_SCHEDULER_FILE_WATCHERS