My Oracle Support Banner

How To Transform Schema Name In Streams (Doc ID 264035.1)

Last updated on JANUARY 31, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.1.0.2 [Release 9.2 to 10.1]
Information in this document applies to any platform.



Goal

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.

For 10g, Please reference the manual
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).

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.