RE: DDL LCR replication in Oracle Streams

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
(INV.INVENTORY_TXN, for ex.).
 

From: Gleb Otochkin [mailto:gleb.otochkin_at_gmail.com] Sent: Friday, January 21, 2011 6:36 AM
To: Hameed, Amir
Cc: oracle-l_at_freelists.org
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.  

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