1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. DBA_STREAMS_TP_COMPONENT_LINK

6.13 DBA_STREAMS_TP_COMPONENT_LINK

DBA_STREAMS_TP_COMPONENT_LINK displays information about how messages flow between Replication components.

Column Datatype NULL Description

SOURCE_COMPONENT_ID

NUMBER

NOT NULL

ID of the source Replication component

SOURCE_COMPONENT_NAME

VARCHAR2(4000)

Name of the source Replication component

SOURCE_COMPONENT_DB

VARCHAR2(128)

Database where the source Replication component resides

SOURCE_COMPONENT_TYPE

VARCHAR2(20)

Type of the source Replication component:

  • CAPTURE

  • PROPAGATION SENDER

  • PROPAGATION RECEIVER

  • APPLY

  • QUEUE

DESTINATION_COMPONENT_ID

NUMBER

NOT NULL

ID of the destination Replication component

DESTINATION_COMPONENT_NAME

VARCHAR2(4000)

Name of the destination Replication component

DESTINATION_COMPONENT_DB

VARCHAR2(128)

Database where the destination Replication component resides

DESTINATION_COMPONENT_TYPE

VARCHAR2(20)

Type of the destination Replication component:

  • CAPTURE

  • PROPAGATION SENDER

  • PROPAGATION RECEIVER

  • APPLY

  • QUEUE

PATH_ID

NUMBER

NOT NULL

ID of the stream path

POSITION

NUMBER

Position of the link within the stream path