RE: DDL LCR replication in Oracle Streams

From: Hameed, Amir <>
Date: Fri, 21 Jan 2011 08:21:42 -0500
Message-ID: <>

Hi Gleb,

RENBAME_SCHEMA only works on DML LCRs and not on DDL LCRs. For DDL LCRs, you will need to write a DDL handler and use SET_CURRENT_SCHEMA procedure to change the owner name. However, this does not work if in your DDL statements, you are qualifying a table name by its owner

From: Gleb Otochkin [] Sent: Friday, January 21, 2011 6:36 AM
To: Hameed, Amir
Subject: Re: DDL LCR replication in Oracle Streams  

Hi Amir,

Have a look to rule-based transformation "rename schema".

It should work in your case.  



On 2011-01-18, at 11:41 AM, Hameed, Amir wrote:


I am looking for an out-of-the-box way of replicating DDL LCRs in 10gR2
(and above) Streams between two databases in a unidirectional
replication (A -> B) configuration when the schema names are different between the source and the target databases. DML replication works fine but DDL LCR are not getting replicated. Any suggestions would be appreciated.  

Thank you


Received on Fri Jan 21 2011 - 07:21:42 CST

Original text of this message