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

VIEW: SYS.CDB_STREAMS_ADD_COLUMN

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

Add column transformations in all containers

[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 (80)
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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_STREAMS_ADD_COLUMN;

Dependencies

[top of page]

SYS.CDB_STREAMS_ADD_COLUMN references the following:

SchemaSYS
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code
SYS.CDB_STREAMS_ADD_COLUMN is referenced by following:

SchemaPUBLIC
SynonymCDB_STREAMS_ADD_COLUMN