OraFAQ Forum: Replication » Use DBMS_REDEFINITION Package with Goldengate 11g

Home » Server Options » Replication » Use DBMS_REDEFINITION Package with Goldengate 11g (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Use DBMS_REDEFINITION Package with Goldengate 11g [message #659571]

Mon, 23 January 2017 02:50

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

Report message to a moderator

Re: Use DBMS_REDEFINITION Package with Goldengate 11g [message #659572 is a reply to message #659571]

Mon, 23 January 2017 02:57

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.

Report message to a moderator

Re: Use DBMS_REDEFINITION Package with Goldengate 11g [message #659577 is a reply to message #659572]

Mon, 23 January 2017 03:24

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

Report message to a moderator

Re: Use DBMS_REDEFINITION Package with Goldengate 11g [message #659596 is a reply to message #659577]

Mon, 23 January 2017 06:35

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.

Report message to a moderator

Previous Topic:	Oracle Golden Gate extract date format
Next Topic:	Replicate the Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 05 03:32:52 CDT 2025