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.

VIEW: SYS.DBA_STREAMS_TP_COMPONENT

Source

View Text - Preformatted


SELECT COMPONENT_ID,
       nvl(COMPONENT_NAME, SPARE3) COMPONENT_NAME,
       COMPONENT_DB,
       decode(COMPONENT_TYPE,
              1, 'CAPTURE',
              2, 'PROPAGATION SENDER',
              3, 'PROPAGATION RECEIVER',
              4, 'APPLY',
              5, 'QUEUE',
              6, 'EXTRACT',
              7, 'REPLICAT',
              NULL) COMPONENT_TYPE,
       COMPONENT_CHANGED_TIME
FROM streams$_component

View Text - HTML Formatted

SELECT COMPONENT_ID
, NVL(COMPONENT_NAME
, SPARE3) COMPONENT_NAME
, COMPONENT_DB
, DECODE(COMPONENT_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION SENDER'
, 3
, 'PROPAGATION RECEIVER'
, 4
, 'APPLY'
, 5
, 'QUEUE'
, 6
, 'EXTRACT'
, 7
, 'REPLICAT'
, NULL) COMPONENT_TYPE
, COMPONENT_CHANGED_TIME FROM STREAMS$_COMPONENT