VIEW: SYS.DBA_SCHEDULER_REMOTE_DATABASES

Source

View Text - Preformatted

SELECT database_name, decode(reg_status, 0, 'SOURCE', 'DESTINATION'),
        database_link
 FROM scheduler$_remote_dbs

View Text - HTML Formatted

SELECT DATABASE_NAME
, DECODE(REG_STATUS
, 0
, 'SOURCE'
, 'DESTINATION')
, DATABASE_LINK
FROM SCHEDULER$_REMOTE_DBS