Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


DBA_STREAMS_TRANSFORMATIONS displays all the transformations available on a system, in order of execution.

Column Datatype NULL Description
RULE_OWNER VARCHAR2(30)   The owner of the rule
RULE_NAME VARCHAR2(30)   The name of the rule
TRANSFORM_TYPE VARCHAR2(26)   The type of the transformation (declarative, subset rule, or user-defined)
FROM_SCHEMA_NAME VARCHAR2(30)   The schema to be renamed
TO_SCHEMA_NAME VARCHAR2(30)   The new schema name
FROM_TABLE_NAME VARCHAR2(30)   The table to be renamed
TO_TABLE_NAME VARCHAR2(30)   The new table name
SCHEMA_NAME VARCHAR2(30)   The schema of the column to be modified
TABLE_NAME VARCHAR2(30)   The table of the column to be modified
FROM_COLUMN_NAME VARCHAR2(4000)   The column to be renamed
TO_COLUMN_NAME VARCHAR2(4000)   The new column name
COLUMN_NAME VARCHAR2(4000)   The column to add or delete
COLUMN_VALUE ANYDATA   The value of the column to add
COLUMN_TYPE VARCHAR2(4000)   The type of the new column
COLUMN_FUNCTION VARCHAR2(30)   The name of the default function
VALUE_TYPE VARCHAR2(3)   Whether to modify the new or old values, or both, of the LCR
USER_FUNCTION_NAME VARCHAR2(4000)   The name of the user-defined transformation
SUBSETTING_OPERATION VARCHAR2(6)   DML operation for row subsetting
DML_CONDITION VARCHAR2(4000)   Row subsetting condition
DECLARATIVE_TYPE VARCHAR2(13)   The type of declarative transform
PRECEDENCE NUMBER   The execution order relative to other declarative transformations on the same STEP_NUMBER
STEP_NUMBER NUMBER   The order in which this transformation should be executed