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

VIEW: SYS.CDB_SCHEDULER_FILE_WATCHERS

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

All scheduler file watch requests in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of file watch request
FILE_WATCHER_NAME VARCHAR2 (30) 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 (30)
Owner of credential that should be used to authorize file watch
CREDENTIAL_NAME VARCHAR2 (30)
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
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      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
,      CON_ID
FROM SYS.CDB_SCHEDULER_FILE_WATCHERS;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_FILE_WATCHERS does not reference any database object

SYS.CDB_SCHEDULER_FILE_WATCHERS is referenced by following:

SchemaPUBLIC
SynonymCDB_SCHEDULER_FILE_WATCHERS