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


VIEW: SYS._DBA_STREAMS_COMPONENT_LINK

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

DBA Streams Component Link

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_COMPONENT_NAME VARCHAR2 (4000)
Name of the source component
SOURCE_COMPONENT_DB VARCHAR2 (4000)
Database on which the source component resides
SOURCE_COMPONENT_TYPE NUMBER

Type of the source component
DEST_COMPONENT_NAME VARCHAR2 (4000)
Name of the destination component
DEST_COMPONENT_DB VARCHAR2 (4000)
Database on which the destination component resides
DEST_COMPONENT_TYPE NUMBER

Type of the destination component
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (0)
SPARE4 DATE

Query Text

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


SELECT SOURCE_COMPONENT_NAME
,      SOURCE_COMPONENT_DB
,      SOURCE_COMPONENT_TYPE
,      DEST_COMPONENT_NAME
,      DEST_COMPONENT_DB
,      DEST_COMPONENT_TYPE
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS._DBA_STREAMS_COMPONENT_LINK;

Dependencies

[top of page]

SYS._DBA_STREAMS_COMPONENT_LINK references the following:

SchemaSYS
ViewDBA_APPLY
ViewGLOBAL_NAME
TableSTREAMS$_CAPTURE_PROCESS
TableSTREAMS$_PROPAGATION_PROCESS
TableXSTREAM$_SERVER
SYS._DBA_STREAMS_COMPONENT_LINK is referenced by following:

SchemaPUBLIC
Synonym_DBA_STREAMS_COMPONENT_LINK
SchemaSYS
Package BodyDBMS_STREAMS_ADV_ADM_UTL_INVOK - show dependent code