Re: ddl replication

From: ddf <oratune_at_msn.com>
Date: Tue, 9 Feb 2016 06:08:09 -0800 (PST)
Message-ID: <c0e6686d-fd40-4264-8cab-9a6596860d65_at_googlegroups.com>


On Tuesday, February 9, 2016 at 5:54:45 AM UTC-7, geos wrote:
> I started to dig the subject of replication in Oracle, specifically DDL
> replication for object from specific schemas. From what I could figure
> out so far it looks like "normally" Oracle GoldenGate can be used to do
> this.
>
> Are there other non-GoldenGate approaches that can do the job? I started
> thinking about DDL triggers. Does it make any sense or maybe I should
> focus on some other way to acomplish ddl replication without GoldenGate?
>
> I would appreciate your opinion and advice.
>
> thank you,
> geos

You need to define what YOU mean by 'DDL replication' -- is this local to the database server and executed between schemas or is this between database servers? How you answer that question makes a huge difference in the answer you receive.

David Fitzjarrell Received on Tue Feb 09 2016 - 15:08:09 CET

Original text of this message