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 |