Re: Suggestion Required: Best Practise for re-org table which is part of Goldengate Extract

You don’t say if you want to reorg origin or destination, but in both cases you can use expdp/impdp to create a copy of your table and configure this copy as target for replication, to maintain in sync. Then create all related objects necessary and schedule a small downtime to rename this table and adjust constraints and other related objects. I’ve done a full reorg using logical standby (dataguard) in the past, with gg should be easier.

Good luck!

On Thu, 28 Sep 2017 at 23:33, Ls Cheng <exriscer_at_gmail.com> wrote:

> you can also use EXCLUDEUSER in TRANLOGOPTIONS, for example create user
> scott and run the reorganization with scott with this extract prm
>
> TRANLOGOPTIONS BUFSIZE 4194304 INTEGRATEDPARAMS (max_sga_size 1024,
> parallelism 2) EXCLUDEUSER SCOTT
>
>
> BR
>
>
>
>
>
> On Thu, Sep 28, 2017 at 4:13 AM, Sourav Biswas <biswas.sourav_at_hotmail.com>
> wrote:
>
>> Thanks Jon, I see your point in excluding the GG schema and then perform
>> Expdp/Impdp using the same schema.
>>
>> I have heard àbout it long time ago, but not tested it. I will definitely
>> test this out and share my experience
>>
>> Thanks again Jon!
>>
>> Thanks & Regards,
>> Sourav Biswas
>>
>> ------------------------------
>> *From:* Jon Crisler <jcrisler_at_us.ibm.com>
>> *Sent:* Thursday, September 28, 2017 7:21:38 AM
>> *To:* biswas.sourav_at_hotmail.com
>> *Cc:* oracle-l_at_freelists.org
>> *Subject:* Re: Suggestion Required: Best Practise for re-org table which
>> is part of Goldengate Extract
>>
>> I cannot post to the list directly, but I can send to you.
>> Another method is to find out the user ID of the Golden Gate user- the
>> schema used for GG itself.
>> You can run "alter table shrink" or expdp / impdp as this user, and GG
>> will ignore the rows that were processed by that user. This way you do not
>> even need to stop any GG process or mess with SCN.
>> If you use rdbms_redefinition , make sure the temp table is excluded from
>> GG as well.
>>
>> -----oracle-l-bounce_at_freelists.org wrote: -----
>> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
>> From: Sourav Biswas
>> Sent by: oracle-l-bounce_at_freelists.org
>> Date: 09/27/2017 06:20PM
>> Subject: Suggestion Required: Best Practise for re-org table which is
>> part of Goldengate Extract
>>
>>
>> Hi All,
>>
>> Can someone provide some documentation or best practices, for re-org
>> tables which are part of Goldengate replication.
>>
>> We have a situation, where we need to re-organize few tables using
>> Datapump. And these tables are a sub-set of huge set of tables which are
>> part of Goldengate extract.
>>
>> An easy way would be to stop the extract , perform the re-org activity
>> and then start the extract after resetting to current csn .
>>
>> I was wondering , in case someone please suggest a better alternative.
>>
>> Best Regards,
>> Sourav Biswas
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l