[Home] [Help] [Dependency Information]
Object Name: | DBA_STREAMS_TRANSFORMATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Transformations defined on rules
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 | |
TRANSFORM_TYPE | VARCHAR2 | (26) | The type of transformation | |
FROM_SCHEMA_NAME | VARCHAR2 | (128) | The schema to be renamed | |
TO_SCHEMA_NAME | VARCHAR2 | (128) | The new schema name | |
FROM_TABLE_NAME | VARCHAR2 | (128) | The table to be renamed | |
TO_TABLE_NAME | VARCHAR2 | (128) | The new table name | |
SCHEMA_NAME | VARCHAR2 | (128) | The schema of the column to be modified | |
TABLE_NAME | VARCHAR2 | (128) | The table of the column to be modified | |
FROM_COLUMN_NAME | VARCHAR2 | (4000) | The column to rename | |
TO_COLUMN_NAME | VARCHAR2 | (4000) | The new column name | |
COLUMN_NAME | VARCHAR2 | (4000) | The column to add or delete | |
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) | ||
USER_FUNCTION_NAME | VARCHAR2 | (4000) | The name of the user-defined transformation function to run | |
SUBSETTING_OPERATION | VARCHAR2 | (6) | DML operation for row subsetting | |
DML_CONDITION | VARCHAR2 | (4000) | Row subsetting condition | |
DECLARATIVE_TYPE | VARCHAR2 | (13) | The type of declarative transformation to run | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_OWNER
, RULE_NAME
, TRANSFORM_TYPE
, FROM_SCHEMA_NAME
, TO_SCHEMA_NAME
, FROM_TABLE_NAME
, TO_TABLE_NAME
, SCHEMA_NAME
, TABLE_NAME
, FROM_COLUMN_NAME
, TO_COLUMN_NAME
, COLUMN_NAME
, COLUMN_VALUE
, COLUMN_TYPE
, COLUMN_FUNCTION
, VALUE_TYPE
, USER_FUNCTION_NAME
, SUBSETTING_OPERATION
, DML_CONDITION
, DECLARATIVE_TYPE
, PRECEDENCE
, STEP_NUMBER
FROM SYS.DBA_STREAMS_TRANSFORMATIONS;
|
|
|