DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_STREAMS_TP_COMPONENT_LINK

Object Details
Object Name: DBA_STREAMS_TP_COMPONENT_LINK
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

DBA Streams Component Link (Streams Topology Links)

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_COMPONENT_ID NUMBER
Yes ID of the Source Streams Component
SOURCE_COMPONENT_NAME VARCHAR2 (4000)
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
DESTINATION_COMPONENT_ID NUMBER
Yes ID of the Destination Streams Component
DESTINATION_COMPONENT_NAME VARCHAR2 (4000)
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
PATH_ID NUMBER
Yes ID of the Stream Path
POSITION NUMBER

Position of the Link within the Stream Path
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOURCE_COMPONENT_ID
,      SOURCE_COMPONENT_NAME
,      SOURCE_COMPONENT_DB
,      SOURCE_COMPONENT_TYPE
,      DESTINATION_COMPONENT_ID
,      DESTINATION_COMPONENT_NAME
,      DESTINATION_COMPONENT_DB
,      DESTINATION_COMPONENT_TYPE
,      PATH_ID
,      POSITION
FROM SYS.DBA_STREAMS_TP_COMPONENT_LINK;

Dependencies

[top of page]

SYS.DBA_STREAMS_TP_COMPONENT_LINK references the following:

SchemaSYS
TableSTREAMS$_COMPONENT
TableSTREAMS$_COMPONENT_LINK
PL/SQL PackageUTL_RAW - show dependent code
SYS.DBA_STREAMS_TP_COMPONENT_LINK is referenced by following:

SchemaPUBLIC
SynonymDBA_STREAMS_TP_COMPONENT_LINK