eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.SCHEDULER$_FILE_WATCHER

Object Details

Object Name:	SCHEDULER$_FILE_WATCHER
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SCHEDULER$_FW_PK

OBJ#

Indexes

Index	Type	Uniqueness	Tablespace	Column
SCHEDULER$_FW_PK	NORMAL	UNIQUE	SYSTEM	OBJ#

Columns

Name	Datatype	Length	Mandatory
OBJ#	NUMBER		Yes
DIRECTORY_PATH	VARCHAR2	(4000)	Yes
FILE_NAME	VARCHAR2	(512)	Yes
DESTINATION	VARCHAR2	(128)
DESTOID	NUMBER
CREDOID	NUMBER
MIN_FILE_SIZE	NUMBER		Yes
STEADY_STATE_DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)
COMMENTS	VARCHAR2	(240)
LAST_MODIFIED_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)
FLAGS	NUMBER

Query Text

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


SELECT OBJ#
,      DIRECTORY_PATH
,      FILE_NAME
,      DESTINATION
,      DESTOID
,      CREDOID
,      MIN_FILE_SIZE
,      STEADY_STATE_DURATION
,      COMMENTS
,      LAST_MODIFIED_TIME
,      FLAGS
FROM SYS.SCHEDULER$_FILE_WATCHER;

Dependencies

[top of page]

SYS.SCHEDULER$_FILE_WATCHER does not reference any database object

SYS.SCHEDULER$_FILE_WATCHER is referenced by following:

SYS: ALL_SCHEDULER_FILE_WATCHERS; DBA_SCHEDULER_FILE_WATCHERS; USER_SCHEDULER_FILE_WATCHERS