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

From: Sourav Biswas <biswas.sourav_at_hotmail.com>
Date: Wed, 27 Sep 2017 22:18:22 +0000
Message-ID: <PN1PR01MB0606EB14A4D9ECDC52397C7FF0780_at_PN1PR01MB0606.INDPRD01.PROD.OUTLOOK.COM>

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

Received on Thu Sep 28 2017 - 00:18:22 CEST

This message: [ Message body ]
Next message: Sourav Biswas: "Re: Suggestion Required: Best Practise for re-org table which is part of Goldengate Extract"
Previous message: Ruan Linehan: "Re: SQL Performance Tuning / CBO Training"
Next in thread: Sourav Biswas: "Re: Suggestion Required: Best Practise for re-org table which is part of Goldengate Extract"
Maybe reply: Sourav Biswas: "Re: Suggestion Required: Best Practise for re-org table which is part of Goldengate Extract"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message