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

TABLE: SYS.STREAMS$_INTERNAL_TRANSFORM

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000365793C00013$$ LOB UNIQUE TablespaceSYSTEM
I_STREAMS_INTERNAL_TRANSFORM1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnRULE_OWNER
ColumnRULE_NAME
Columns
Name Datatype Length Mandatory Comments
RULE_OWNER VARCHAR2 (128) Yes
RULE_NAME VARCHAR2 (128) Yes
DECLARATIVE_TYPE NUMBER

FROM_SCHEMA_NAME VARCHAR2 (128)
TO_SCHEMA_NAME VARCHAR2 (128)
FROM_TABLE_NAME VARCHAR2 (128)
TO_TABLE_NAME VARCHAR2 (128)
SCHEMA_NAME VARCHAR2 (128)
TABLE_NAME VARCHAR2 (128)
FROM_COLUMN_NAME VARCHAR2 (4000)
TO_COLUMN_NAME VARCHAR2 (4000)
COLUMN_NAME VARCHAR2 (4000)
COLUMN_VALUE ANYDATA (3748)
COLUMN_TYPE NUMBER

COLUMN_FUNCTION VARCHAR2 (128)
VALUE_TYPE NUMBER

STEP_NUMBER NUMBER

PRECEDENCE NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (4000)
Query Text

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


SELECT RULE_OWNER
,      RULE_NAME
,      DECLARATIVE_TYPE
,      FROM_SCHEMA_NAME
,      TO_SCHEMA_NAME
,      FROM_TABLE_NAME
,      TO_TABLE_NAME
,      SCHEMA_NAME
,      TABLE_NAME
,      FROM_COLUMN_NAME
,      TO_COLUMN_NAME
,      COLUMN_NAME
,      COLUMN_VALUE
,      COLUMN_TYPE
,      COLUMN_FUNCTION
,      VALUE_TYPE
,      STEP_NUMBER
,      PRECEDENCE
,      SPARE1
,      SPARE2
,      SPARE3
FROM SYS.STREAMS$_INTERNAL_TRANSFORM;

Dependencies

[top of page]

SYS.STREAMS$_INTERNAL_TRANSFORM references the following:

SchemaSYS
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code
SYS.STREAMS$_INTERNAL_TRANSFORM is referenced by following:

SchemaSYS
View_DBA_STREAMS_TRANSFORMATIONS