Re: DDL LCR replication in Oracle Streams

From: Gleb Otochkin <gleb.otochkin_at_gmail.com>
Date: Fri, 21 Jan 2011 06:35:32 -0500
Message-Id: <6F4BDE20-80A0-47C1-A5EC-A1953C57251B_at_gmail.com>



Hi Amir,
Have a look to rule-based transformation "rename schema". It should work in your case.

Cheers,
Gleb

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

> Hi,
> 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
> Amir
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 21 2011 - 05:35:32 CST

Original text of this message