Home » Server Options » Replication » Use DBMS_REDEFINITION Package with Goldengate 11g (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)
Use DBMS_REDEFINITION Package with Goldengate 11g [message #659571] Mon, 23 January 2017 02:50 Go to next message
imrankhan1983
Messages: 2
Registered: January 2017
Junior Member
Hi All,

we need to partition a table online, We are doing it using DBMS_REDEFINITION package and it is working perfectly for us. Now we have a requirement to do it in a database where Goldengate is also configured.

Can we use DBMS_REDEFINITION Package with Goldengate 11g without impacting the GG replication?

Many Thanks in advance.

Regards,
Imran
Re: Use DBMS_REDEFINITION Package with Goldengate 11g [message #659572 is a reply to message #659571] Mon, 23 January 2017 02:57 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
The last I checked this generally doesn't work, however GG has frequent release cycles so this may have improved.

We'd usually end up rebuilding the target in such an event.
Re: Use DBMS_REDEFINITION Package with Goldengate 11g [message #659577 is a reply to message #659572] Mon, 23 January 2017 03:24 Go to previous messageGo to next message
imrankhan1983
Messages: 2
Registered: January 2017
Junior Member
Thanks Mate for your quick reply. Have you checked this recently?

In addition i found following link on this.

http://kamrans-notes.blogspot.qa/2013/04/dbmsredefinition-gg.html
Re: Use DBMS_REDEFINITION Package with Goldengate 11g [message #659596 is a reply to message #659577] Mon, 23 January 2017 06:35 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Nope. There are so many OGG releases I only ever use the documentation for the release in question tbh.
Previous Topic: Oracle Golden Gate extract date format
Next Topic: Replicate the Database
Goto Forum:
  


Current Time: Thu Mar 28 12:11:45 CDT 2024