DBA_STREAMS_RENAME_COLUMN

DBA_STREAMS_RENAME_COLUMN displays information about renamed columns in the Streams capture process.

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