3.163 ALL_XSTREAM_TRANSFORMATIONS

ALL_XSTREAM_TRANSFORMATIONS displays information about all XStream transformations accessible to the current user, in order of execution.

Related View

DBA_XSTREAM_TRANSFORMATIONS displays information about all XStream transformations available on a system, in order of execution.

Column Datatype NULL Description

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)

Type of the transformation:

  • DECLARATIVE TRANSFORMATION

  • SUBSET RULE

  • CUSTOM TRANSFORMATION

FROM_SCHEMA_NAME

VARCHAR2(128)

Schema to be renamed

TO_SCHEMA_NAME

VARCHAR2(128)

New schema name

FROM_TABLE_NAME

VARCHAR2(128)

Table to be renamed

TO_TABLE_NAME

VARCHAR2(128)

New table name

SCHEMA_NAME

VARCHAR2(128)

Schema of the column to be modified

TABLE_NAME

VARCHAR2(128)

Table of the column to be modified

FROM_COLUMN_NAME

VARCHAR2(4000)

Column to be renamed

TO_COLUMN_NAME

VARCHAR2(4000)

New column name

COLUMN_NAME

VARCHAR2(4000)

Column to add or delete

COLUMN_VALUE

ANYDATA

Value of the column to add

COLUMN_TYPE

VARCHAR2(4000)

Type of the new column

COLUMN_FUNCTION

VARCHAR2(128)

Name of the default function used to add a column

VALUE_TYPE

VARCHAR2(3)

Indicates whether to modify the old (OLD), new (NEW), or both (*) values of the LCR

USER_FUNCTION_NAME

VARCHAR2(4000)

Name of the user-defined transformation function to run

SUBSETTING_OPERATION

VARCHAR2(6)

DML operation for row subsetting:

  • INSERT

  • UPDATE

  • DELETE

DML_CONDITION

VARCHAR2(4000)

Row subsetting condition

DECLARATIVE_TYPE

VARCHAR2(13)

Type of declarative transform to run:

  • KEEP COLUMNS

  • DELETE COLUMN

  • RENAME COLUMN

  • ADD COLUMN

  • RENAME TABLE

  • RENAME SCHEMA

PRECEDENCE

NUMBER

Execution order relative to other declarative transformations on the same STEP_NUMBER

STEP_NUMBER

NUMBER

Order in which this transformation should be executed