[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_INTERNAL_TRANSFORM |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000365793C00013$$ | LOB | UNIQUE | SYSTEM | |
I_STREAMS_INTERNAL_TRANSFORM1 | NORMAL | NONUNIQUE | SYSTEM |
RULE_OWNER
RULE_NAME |
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) |
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;
|
|
|