Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

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

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

DBA_STREAMS_TRANSFORMATIONS

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

Column Datatype NULL Description
RULE_OWNER VARCHAR2(30)   Owner of the rule
RULE_NAME VARCHAR2(30)   Name of the rule
TRANSFORM_TYPE VARCHAR2(26)   Type of the transformation:
  • DECLARATIVE TRANSFORMATION

  • SUBSET RULE

  • CUSTOM TRANSFORMATION

FROM_SCHEMA_NAME VARCHAR2(30)   Schema to be renamed
TO_SCHEMA_NAME VARCHAR2(30)   New schema name
FROM_TABLE_NAME VARCHAR2(30)   Table to be renamed
TO_TABLE_NAME VARCHAR2(30)   New table name
SCHEMA_NAME VARCHAR2(30)   Schema of the column to be modified
TABLE_NAME VARCHAR2(30)   Table of the column to be modified
FROM_COLUMN_NAME VARCHAR2(4000)   Column to be renamed
TO_COLUMN_NAME VARCHAR2(4000)   New column name
COLUMN_NAME VARCHAR2(4000)   Column to add or delete
COLUMN_VALUE ANYDATA   Value of the column to add
COLUMN_TYPE VARCHAR2(4000)   Type of the new column
COLUMN_FUNCTION VARCHAR2(30)   Name of the default function used to add a column
VALUE_TYPE VARCHAR2(3)   Indicates whether to modify the old (OLD), new (NEW), or both (*) values of the LCR
USER_FUNCTION_NAME VARCHAR2(4000)   Name of the user-defined transformation function to run
SUBSETTING_OPERATION VARCHAR2(6)   DML operation for row subsetting:
  • INSERT

  • UPDATE

  • DELETE

DML_CONDITION VARCHAR2(4000)   Row subsetting condition
DECLARATIVE_TYPE VARCHAR2(13)   Type of declarative transform:
  • KEEP COLUMNS

  • DELETE COLUMN

  • RENAME COLUMN

  • ADD COLUMN

  • RENAME TABLE

  • RENAME SCHEMA

PRECEDENCE NUMBER   Execution order relative to other declarative transformations on the same STEP_NUMBER
STEP_NUMBER NUMBER   Order in which this transformation should be executed