Re: DDL LCR replication in Oracle Streams

  • From: Gleb Otochkin <gleb.otochkin@xxxxxxxxx>
  • To: Amir.Hameed@xxxxxxxxx
  • Date: Fri, 21 Jan 2011 06:35:32 -0500

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
>  

Other related posts: