Re: ddl replication

On 09.02.2016 15:08, ddf wrote:
> 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.

Good point. Initially I thought about two different instances but it looks to me like it could also be between two schemas within one instance, like from PROD to PROD_REP. Definitely it will be one-way. I would like to replicate any change in the schema objects like adding new column to a table, dropping a table, creating view, sequence etc.

I would appreciate your advice for both scenarios so that I could think about it.

thank you,
geos Received on Tue Feb 09 2016 - 16:30:14 CET