How To Transform Schema Name In Streams
(Doc ID 264035.1)
Last updated on JANUARY 31, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 10.1.0.2 [Release 9.2 to 10.1]
Information in this document applies to any platform.
The purpose of this article is to demonstrate replicating data
from a table in one schema to a table in a different schema by transforming the
name of the schema in the change event captured by Oracle Streams.
The scope of this article is limited to DML changes to the table and is not applicable to DDL changes.
10.2 Streams Concepts and Administration
Chapter 7 Rule-Based Transformations
Displaying Declarative Rule-Based Transformations
The following types are possible:
ADD COLUMN, DELETE COLUMN, RENAME COLUMN, RENAME SCHEMA, and RENAME TABLE
In the example shown below, DML changes to a table called EXAMPLE belonging to
schema HR are captured and applied to a table EXAMPLE belonging to schema TEST
within the same database. This is acheived by a transformation that modifies
the values of the schema name within the Logical Change Record (LCR).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!