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

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