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