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

VIEW: SYS.DBA_STREAMS_KEEP_COLUMNS

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

Keep columns 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 kept
TABLE_NAME VARCHAR2 (128)
The table of the column to be kept
COLUMN_NAME VARCHAR2 (4000)
The column to keep
VALUE_TYPE VARCHAR2 (3)
Whether to keep the old column 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
,      VALUE_TYPE
,      PRECEDENCE
,      STEP_NUMBER
FROM SYS.DBA_STREAMS_KEEP_COLUMNS;

Dependencies

[top of page]

SYS.DBA_STREAMS_KEEP_COLUMNS 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
SYS.DBA_STREAMS_KEEP_COLUMNS is referenced by following:

SchemaPUBLIC
SynonymDBA_STREAMS_KEEP_COLUMNS
SchemaSYS
ViewALL_STREAMS_KEEP_COLUMNS