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


TABLE: SYS.STREAMS$_COMPONENT_PROP

Object Details
Object Name: STREAMS$_COMPONENT_PROP
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
STREAMS$_COMPONENT_PROP_IND NORMAL UNIQUE TablespaceSYSAUX ColumnCOMPONENT_ID
ColumnPROP_NAME
Columns
Name Datatype Length Mandatory Comments
COMPONENT_ID NUMBER
Yes
PROP_NAME VARCHAR2 (128)
PROP_VALUE VARCHAR2 (4000)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (4000)
SPARE4 DATE

Query Text

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


SELECT COMPONENT_ID
,      PROP_NAME
,      PROP_VALUE
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.STREAMS$_COMPONENT_PROP;

Dependencies

[top of page]

SYS.STREAMS$_COMPONENT_PROP does not reference any database object

SYS.STREAMS$_COMPONENT_PROP is referenced by following:

SchemaSYS
Package BodyDBMS_STREAMS_ADV_ADM_UTL - show dependent code
View_DBA_STREAMS_TP_COMPONENT_PROP