| 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 |