No question at this time
DBA Top 10
1 B. Vroman 15300
2 M. Cadot 12400
3 J. Schnackenberg 7400
4 T. Boles 6950
5 A. Kavsek 6900
6 M. Hidayathullah ... 3300
7 T. P 1300
8 G. Lambregts 1100
8 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48245
Total active users1631
Act. users last 24h3
Act. users last hour0
Registered user hits last week190
Registered user hits last month742
Go up

GoldenGate (12.1) replication issue
Next thread: using Oracle pl/sql to access web services
Prev thread: RAC cluster down

Message Score Author Date
I have partition table T1 in databse1 and databas...... Venkata S Jun 10, 2018, 04:08
Hi Venkata, please share the error log from ext...... javed akhtar Jun 11, 2018, 14:30

Follow up by mail Click here


Subject: GoldenGate (12.1) replication issue
Author: Venkata S, India
Date: Jun 10, 2018, 04:08, 70 days ago
Os info: red hat linux 7
Oracle info: 11.2
Message: I have partition table T1 in databse1 and database2.

In database1 table T1 is partitioned by range and has monthly partitions.

In database2 table T1 is partitioned by range and has daily partitions.

I am replicating data from datbase1 to databse2 using GG.

on databse2 replication is working fine for insert statements. however replication is abended for update and delete.

Please help me with the solution, how we can replicate between two partition tables which has different structure. number of columns and order is same.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: GoldenGate (12.1) replication issue
Author: javed akhtar, India
Date: Jun 11, 2018, 14:30, 69 days ago
Message: Hi Venkata,

please share the error log from extract and replication side.

thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here