Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
DBA_STREAMS_RENAME_COLUMN
displays information about declarative rule-based transformations that rename a column in a row logical change record (LCR).
Column | Datatype | NULL | Description |
---|---|---|---|
RULE_OWNER |
VARCHAR2(30) |
Owner of the rule | |
RULE_NAME |
VARCHAR2(30) |
Name of the rule | |
SCHEMA_NAME |
VARCHAR2(30) |
Schema of the column to be renamed | |
TABLE_NAME |
VARCHAR2(30) |
Table of the column to be renamed | |
FROM_COLUMN_NAME |
VARCHAR2(4000) |
Column to rename | |
TO_COLUMN_NAME |
VARCHAR2(4000) |
New column name | |
VALUE_TYPE |
VARCHAR2(3) |
Indicates whether to modify the old (OLD ), new (NEW ), or both (* ) values of the LCR |
|
PRECEDENCE |
NUMBER |
2 (the execution order relative to other transformations on the same STEP_NUMBER ; the smaller number will be executed first) |
|
STEP_NUMBER |
NUMBER |
Order in which this transformation should be executed |