[Home] [Help] [Dependency Information]
Object Name: | DBA_STREAMS_TP_COMPONENT_LINK |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
DBA Streams Component Link (Streams Topology Links)
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 |
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;
|
|
|