eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TYPE: SYS.STREAMS$TRANSFORMATION_INFO

Object Details

Object Name:	STREAMS$TRANSFORMATION_INFO
Object Type:	TYPE
Owner:	SYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
TRANSFORM_TYPE	NUMBER
OPERATION	NUMBER
FROM_SCHEMA_NAME	VARCHAR2	(30)
TO_SCHEMA_NAME	VARCHAR2	(30)
FROM_TABLE_NAME	VARCHAR2	(30)
TO_TABLE_NAME	VARCHAR2	(30)
SCHEMA_NAME	VARCHAR2	(30)
TABLE_NAME	VARCHAR2	(30)
VALUE_TYPE	NUMBER
FROM_COLUMN_NAME	VARCHAR2	(4000)
TO_COLUMN_NAME	VARCHAR2	(4000)
COLUMN_NAME	VARCHAR2	(4000)
COLUMN_VALUE_VC2	VARCHAR2	(4000)
COLUMN_VALUE_RAW	RAW	(4000)
COLUMN_VALUE_NUM	NUMBER
COLUMN_VALUE_DATE	DATE
COLUMN_VALUE_NVC2	NVARCHAR2	(2000)
COLUMN_VALUE_BFLT	BINARY_FLOAT
COLUMN_VALUE_BDBL	BINARY_DOUBLE
COLUMN_VALUE_TS	TIMESTAMP
COLUMN_VALUE_TZ	TIMESTAMP WITH TZ
COLUMN_VALUE_LTZ	TIMESTAMP WITH LOCAL TZ
COLUMN_VALUE_IYM	INTERVAL YEAR TO MONTH		2
COLUMN_VALUE_IDS	INTERVAL DAY TO SECOND		2
COLUMN_VALUE_CHAR	CHAR	(2000)
COLUMN_VALUE_NCHAR	NCHAR	(1000)
COLUMN_VALUE_URID	VARCHAR2	(4000)
COLUMN_TYPE	NUMBER
COLUMN_FUNCTION	VARCHAR2	(4000)
STEP_NUMBER	NUMBER

Dependencies

[top of page]

SYS.STREAMS$TRANSFORMATION_INFO references the following:

SYS: STANDARD - show dependent code

SYS.STREAMS$TRANSFORMATION_INFO is referenced by following:

SYS: DBMS_STREAMS_ADM_IVK - show dependent code