DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_STREAMS_ADD_COLUMN

Object Details
Object Name: DBA_STREAMS_ADD_COLUMN
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Add column transformations

[View Source]

Columns
Name Datatype Length Mandatory Comments
RULE_OWNER VARCHAR2 (128)
Owner of the rule which has an associated transformation
RULE_NAME VARCHAR2 (128)
Name of the rule which has an associated transformation
SCHEMA_NAME VARCHAR2 (128)
The schema of the column to be modified
TABLE_NAME VARCHAR2 (128)
The table of the column to be modified
COLUMN_NAME VARCHAR2 (4000)
The column to add
COLUMN_VALUE ANYDATA (64)
The value of the column to add
COLUMN_TYPE VARCHAR2 (4000)
The type of the new column
COLUMN_FUNCTION VARCHAR2 (128)
The name of the default function used to add a column
VALUE_TYPE VARCHAR2 (3)
Whether to add to the old value of the lcr, the new value, or both
PRECEDENCE NUMBER

Execution order relative to other declarative transformations on the same step_number
STEP_NUMBER NUMBER

The order that this transformation should be executed
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_OWNER
,      RULE_NAME
,      SCHEMA_NAME
,      TABLE_NAME
,      COLUMN_NAME
,      COLUMN_VALUE
,      COLUMN_TYPE
,      COLUMN_FUNCTION
,      VALUE_TYPE
,      PRECEDENCE
,      STEP_NUMBER
FROM SYS.DBA_STREAMS_ADD_COLUMN;

Dependencies

[top of page]

SYS.DBA_STREAMS_ADD_COLUMN references the following:

SchemaSYS
TYPEANYDATA
ViewDBA_STREAMS_TRANSFORMATIONS
PL/SQL PackageDBMS_LOB - show dependent code
PL/SQL PackageDBMS_LOGREP_UTIL - show dependent code
FunctionGET_MAX_CHECKPOINT
TYPERE$NV_ARRAY
PL/SQL PackageSTANDARD - show dependent code
SYS.DBA_STREAMS_ADD_COLUMN is referenced by following:

SchemaPUBLIC
SynonymDBA_STREAMS_ADD_COLUMN