Re: ddl replication

From: ddf <>
Date: Tue, 9 Feb 2016 06:08:09 -0800 (PST)
Message-ID: <>

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