Re: If reorganizing oracle table on the source of oracle golden gate then it'll be effected the sync situation on the target of oralce golden gate?
From: Andy Sayer <andysayer_at_gmail.com>
Date: Wed, 15 Mar 2023 18:39:47 -0700
Message-ID: <CACj1VR45z4cGgCAM4MYW14PW5jN+r7XBsj=canWfEWKvnomRoA_at_mail.gmail.com>
Date: Wed, 15 Mar 2023 18:39:47 -0700
Message-ID: <CACj1VR45z4cGgCAM4MYW14PW5jN+r7XBsj=canWfEWKvnomRoA_at_mail.gmail.com>
Be sure to test on your own environments. But when I tested, this was a no
impact operation. I’ve also tested dbms_redefinition and it was also
handled fine. This is going to probably depend on the versions of
everything so do double check!
Thanks,
On Wed, Mar 15, 2023 at 6:17 PM, Quanwen Zhao <quanwenzhao_at_gmail.com> wrote:
> Hello listeners,
Andy
>
> If reorganizing oracle table on the source of oracle golden gate then
> it'll be effected the sync situation on the target of oralce golden gate?
> The reorganizing table is the online operation such as table move or
> shrink. Thanks in advance.
>
> Best Regards
> Quanwen Zhao
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 16 2023 - 02:39:47 CET