Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_STREAMS_TP_COMPONENT_LINK

DBA_STREAMS_TP_COMPONENT_LINK displays information about how messages flow between Oracle Streams components.

Column Datatype NULL Description
SOURCE_COMPONENT_ID NUMBER NOT NULL ID of the source Streams component
SOURCE_COMPONENT_NAME VARCHAR2(194)   Name of the source Streams component
SOURCE_COMPONENT_DB VARCHAR2(128)   Database where the source Streams component resides
SOURCE_COMPONENT_TYPE VARCHAR2(20)   Type of the source Streams component:
  • CAPTURE

  • PROPAGATION SENDER

  • PROPAGATION RECEIVER

  • APPLY

  • QUEUE

DESTINATION_COMPONENT_ID NUMBER NOT NULL ID of the destination Streams component
DESTINATION_COMPONENT_NAME VARCHAR2(194)   Name of the destination Streams component
DESTINATION_COMPONENT_DB VARCHAR2(128)   Database where the destination Streams component resides
DESTINATION_COMPONENT_TYPE VARCHAR2(20)   Type of the destination Streams 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
ACTIVE VARCHAR2(3)   Indicates whether the Link is on an Active stream Path (YES) or not (NO)
ORIGINAL_PATH_ID NUMBER   ID of the Original stream Path for the Optimized Path