ALL_SCHEDULER_REMOTE_DATABASES displays information about the remote databases accessible to the current user that have been registered as sources and destinations for remote database jobs.
DBA_SCHEDULER_REMOTE_DATABASES displays information about all remote databases that have been registered as sources and destinations for remote database jobs.
| Column | Datatype | NULL | Description |
|---|---|---|---|
DATABASE_NAME |
VARCHAR2(512) |
NOT NULL |
Global name of the remote database |
REGISTERED_AS |
VARCHAR2(11) |
Indicates whether the database is registered as a source (SOURCE) or as a destination (DESTINATION) |
|
DATABASE_LINK |
VARCHAR2(512) |
NOT NULL |
Name of a valid database link to the remote database |
See Also:
"DBA_SCHEDULER_REMOTE_DATABASES"