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


VIEW: SYS.CDB_STREAMS_TP_COMPONENT_LINK

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

DBA Streams Component Link (Streams Topology Links) in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_STREAMS_TP_COMPONENT_LINK;

Dependencies

[top of page]

SYS.CDB_STREAMS_TP_COMPONENT_LINK does not reference any database object

SYS.CDB_STREAMS_TP_COMPONENT_LINK is referenced by following:

SchemaPUBLIC
SynonymCDB_STREAMS_TP_COMPONENT_LINK