Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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
PDF · Mobi · ePub

DBA_STREAMS_ADD_COLUMN

DBA_STREAMS_ADD_COLUMN displays information about new columns in the Streams capture process.

Column Datatype NULL Description
RULE_OWNER VARCHAR2(30)   The owner of the rule
RULE_NAME VARCHAR2(30)   The name of the rule
SCHEMA_NAME VARCHAR2(30)   The schema of the column to be added
TABLE_NAME VARCHAR2(30)   The table of the column to be added
COLUMN_NAME VARCHAR2(4000)   The name of the column to be added
COLUMN_VALUE ANYDATA   The value of the column to be added
COLUMN_TYPE VARCHAR2(4000)   The type of the column to be added
COLUMN_FUNCTION VARCHAR2(30)   The name of the default function
VALUE_TYPE VARCHAR2(3)   Whether to modify the old or new values of the LCR
PRECEDENCE NUMBER   3 (The execution order relative to other transformations on the same STEP_NUMBER; the smaller number will be executed first.)
STEP_NUMBER NUMBER   The order in which this transformation should be executed.