VIEW: SYS.DBA_STREAMS_TP_COMPONENT_LINK

Source

View Text - Preformatted

SELECT L.SOURCE_COMPONENT_ID,
       nvl(S.COMPONENT_NAME, S.SPARE3) COMPONENT_NAME,
       S.COMPONENT_DB,
       decode(S.COMPONENT_TYPE,
              1, 'CAPTURE',
              2, 'PROPAGATION SENDER',
              3, 'PROPAGATION RECEIVER',
              4, 'APPLY',
              5, 'QUEUE',
              6, 'EXTRACT',
              7, 'REPLICAT',
              NULL),
       L.DEST_COMPONENT_ID,
       nvl(D.COMPONENT_NAME, D.SPARE3) COMPONENT_NAME,
       D.COMPONENT_DB,
       decode(D.COMPONENT_TYPE,
              1, 'CAPTURE',
              2, 'PROPAGATION SENDER',
              3, 'PROPAGATION RECEIVER',
              4, 'APPLY',
              5, 'QUEUE',
              6, 'EXTRACT',
              7, 'REPLICAT',
              NULL),
       L.PATH_ID,
       L.POSITION
FROM streams$_component S,
     streams$_component D,
     streams$_component_link L
WHERE L.SOURCE_COMPONENT_ID = S.COMPONENT_ID AND
      L.DEST_COMPONENT_ID = D.COMPONENT_ID AND
   -- Display active stream paths only
   -- '00000001' is ACTIVE_PATH_FLAG defined by dbms_streams_adv_adm_utl
      utl_raw.bit_and(L.PATH_FLAG, '00000001') = '00000001'

View Text - HTML Formatted

SELECT L.SOURCE_COMPONENT_ID
, NVL(S.COMPONENT_NAME
, S.SPARE3) COMPONENT_NAME
, S.COMPONENT_DB
, DECODE(S.COMPONENT_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION SENDER'
, 3
, 'PROPAGATION RECEIVER'
, 4
, 'APPLY'
, 5
, 'QUEUE'
, 6
, 'EXTRACT'
, 7
, 'REPLICAT'
, NULL)
, L.DEST_COMPONENT_ID
, NVL(D.COMPONENT_NAME
, D.SPARE3) COMPONENT_NAME
, D.COMPONENT_DB
, DECODE(D.COMPONENT_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION SENDER'
, 3
, 'PROPAGATION RECEIVER'
, 4
, 'APPLY'
, 5
, 'QUEUE'
, 6
, 'EXTRACT'
, 7
, 'REPLICAT'
, NULL)
, L.PATH_ID
, L.POSITION FROM STREAMS$_COMPONENT S
, STREAMS$_COMPONENT D
, STREAMS$_COMPONENT_LINK L WHERE L.SOURCE_COMPONENT_ID = S.COMPONENT_ID AND L.DEST_COMPONENT_ID = D.COMPONENT_ID AND -- DISPLAY ACTIVE STREAM PATHS ONLY -- '00000001' IS ACTIVE_PATH_FLAG DEFINED BY DBMS_STREAMS_ADV_ADM_UTL UTL_RAW.BIT_AND(L.PATH_FLAG
, '00000001') = '00000001'