Home » Server Options » Replication » golden gate replication to partitioned table (golden gate 12c on rhel 5)
golden gate replication to partitioned table [message #651886] Thu, 26 May 2016 14:07 Go to next message
ssumesh
Messages: 4
Registered: May 2015
Location: delhi
Junior Member
Hi friends,

I am using ogg 12c on rhel 5. Source and target both are oracle 11.2.

My source and target were having few large tables. Requirement is to partition them on target side and leave it partitioned on source.

As soon as i partition one of the target table, OGG replicate abbend with TABLE MAPPING error.

I am using ASSUMETARGETDEFS in my replicate parameter file.

Please help me to find.

The above setup is possible or not (supported by ogg)??

if yes has anybody done such earlier? I was thinking to use DEFGEN to copy source DDL to target, will it help ?

Thanks
Re: golden gate replication to partitioned table [message #652071 is a reply to message #651886] Tue, 31 May 2016 19:41 Go to previous message
kgan238
Messages: 2
Registered: May 2016
Location: Australia
Junior Member
If you run 12.2 OGG you can remove ASSUMETARGETDEFS as the metadata is now carried within the OGG trails. So you can change what you like on the source and the replicat will know what to do. In any case a partition change should not change the table columns per se so it should not crash. Can you copy the error here?
The replicat does not care where it resides as long as the columns and data types do not change.
Cheers
Kee Gan
Previous Topic: Rowid ORACLE Golden Gate
Next Topic: Stream Replication b/t 11g and 10 (merged)
Goto Forum:
  


Current Time: Mon Nov 20 11:23:59 CST 2017

Total time taken to generate the page: 0.01500 seconds