This discussion is archived
3 Replies Latest reply: Nov 26, 2012 7:23 AM by satrap RSS

Exclude truncate of 3000 partitions in Golden Gate

637059 Newbie
Currently Being Moderated
Hi,

We have a table with 4000 partitions and we would like to exclude a truncate of 3000 partitions out of the 4000 in out extract / replicat gg files .

Does anyone have a creative solution for this ?

Thanks in advanced.
  • 1. Re: Exclude truncate of 3000 partitions in Golden Gate
    satrap Journeyer
    Currently Being Moderated
    Remember that Oracle GoldenGate supports the Oracle TRUNCATE TABLE command without enabling DDL(using GETTRUNCATES), but not TRUNCATE PARTITION. You can replicate TRUNCATE PARTITION as part of the full Oracle GoldenGate DDL replication support.
    Assuming you have DDL replication enabled, disable the DDL replication and then truncate the 3000 partitions. Once done, enable the DDL replication again.
  • 2. Re: Exclude truncate of 3000 partitions in Golden Gate
    637059 Newbie
    Currently Being Moderated
    Hi,

    This is not a one time execution !

    We want a solution for an active application and we want to exclude the ddl operations of truncate specific partitions .

    Thanks a lot !

    -Nitzan
  • 3. Re: Exclude truncate of 3000 partitions in Golden Gate
    satrap Journeyer
    Currently Being Moderated
    If you know the names of the partitions you do not want to replicate, you can try with DDL EXCLUDE. e.g. The below should include all DDL for replication except the truncates of partitions p1

    DDL INCLUDE ALL EXCLUDE INSTR ‘ ALTER TABLE FACT.ORDER TRUNCATE PARTITION P1'.

    you can try with wildcard for the partition names if they have names containing same characters. Go through oracle documentation on DDL exlude.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points