RE: DDL LCR replication in Oracle Streams
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: "Gleb Otochkin" <gleb.otochkin@xxxxxxxxx>
- Date: Fri, 21 Jan 2011 08:21:42 -0500
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
(INV.INVENTORY_TXN, for ex.).
From: Gleb Otochkin [mailto:gleb.otochkin@xxxxxxxxx]
Sent: Friday, January 21, 2011 6:36 AM
To: Hameed, Amir
Cc: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
