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


VIEW: SYS._DBA_STREAMS_COMPONENT_PROP

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

DBA Streams Component Properties

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPONENT_NAME VARCHAR2 (128)
Name of the streams component
COMPONENT_DB VARCHAR2 (4000)
Database on which the streams component resides
COMPONENT_TYPE NUMBER

Type of the streams component
PROP_NAME VARCHAR2 (21)
Name of the property
PROP_VALUE VARCHAR2 (4000)
Value of the property
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (0)
SPARE4 DATE

Query Text

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


SELECT COMPONENT_NAME
,      COMPONENT_DB
,      COMPONENT_TYPE
,      PROP_NAME
,      PROP_VALUE
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS._DBA_STREAMS_COMPONENT_PROP;

Dependencies

[top of page]

SYS._DBA_STREAMS_COMPONENT_PROP references the following:

SchemaSYS
ViewDBA_APPLY
ViewGLOBAL_NAME
TableSTREAMS$_APPLY_MILESTONE
TableSTREAMS$_APPLY_PROCESS
TableSTREAMS$_CAPTURE_PROCESS
TableSTREAMS$_PROCESS_PARAMS
PL/SQL PackageUTL_RAW - show dependent code
View_GV$SXGG_APPLY_SERVER
View_GV$SXGG_CAPTURE
SYS._DBA_STREAMS_COMPONENT_PROP is referenced by following:

SchemaPUBLIC
Synonym_DBA_STREAMS_COMPONENT_PROP
SchemaSYS
Package BodyDBMS_STREAMS_ADV_ADM_UTL_INVOK - show dependent code