Forum Stats

  • 3,815,831 Users
  • 2,259,097 Discussions
  • 7,893,270 Comments

Discussions

Exclude extract/replicat certain period of time/data

hsemar
hsemar Member Posts: 117 Blue Ribbon

Hi,

We have a requirement that the during the deployment we don't wan the goldengate to capture the information of certain period of time.


Is there a way to handle these kind of situation. We can't keep on altering the replciate for every deployment that we do.


Regards,

Ramesh G

Tagged:

Answers

  • ORASCN
    ORASCN Member Posts: 1,868 Bronze Crown

    Hi Ramesh,

    What I would suggest is,

    1. create a user. For example GGEXCLUDE
    2. Exclude this user in Extract using the parameter TRANLOGOPTIONS EXCLUDEUSER
    3. Ask the application team to perform the deployment using this user, so that it won't be captured by the Extract process.
    4. But this user should be give appropriate privileges.

    This makes the work simpler.

    Regards,

    Veera

  • Vikas Panwar
    Vikas Panwar Member Posts: 289 Bronze Badge

    stop your extract and start when deployment is done

    then use alter extract with begin timestamp option.


    Regards,

    VP