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

Part Number E10820-02
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
View PDF

DBA_STREAMS_RENAME_COLUMN

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