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

TABLE: SYS.SCHEDULER$_REMOTE_DBS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SCHEDULER$_RDB_PK
  1. ColumnDATABASE_NAME
  2. ColumnREG_STATUS
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_RDB_PK NORMAL UNIQUE TablespaceSYSTEM ColumnDATABASE_NAME
ColumnREG_STATUS
Columns
Name Datatype Length Mandatory Comments
DATABASE_NAME VARCHAR2 (512) Yes
REG_STATUS NUMBER
Yes
DB_INDEX NUMBER
Yes
DATABASE_LINK VARCHAR2 (512) Yes
Query Text

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


SELECT DATABASE_NAME
,      REG_STATUS
,      DB_INDEX
,      DATABASE_LINK
FROM SYS.SCHEDULER$_REMOTE_DBS;

Dependencies

[top of page]

SYS.SCHEDULER$_REMOTE_DBS does not reference any database object

SYS.SCHEDULER$_REMOTE_DBS is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_REMOTE_DATABASES
ViewDBA_SCHEDULER_REMOTE_DATABASES