Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OGG for Big Data table truncates

sky_yowMar 20 2017 — edited Mar 23 2017

Hello,

Documentation says that truncates are supposed to be replicated and have an operation code "T" on the file on the destination system.

Somehow I don't see the truncates to be replicated. I see updates, deletes and inserts but no truncate commands.

I tried with HDFS, Kafka and Flume adapters but no luck. Maybe I am doing something wrong.

I can clearly see that "stats" command shows counter of DDL command growing with each truncate :

DDL replication statistics:

*** Total statistics since replicat started     ***

  Operations                           4.00

  Mapped operations                   4.00

  Unmapped operations                   0.00

  Other operations                   0.00

  Excluded operations                   0.00

  Errors                               0.00

  Retried errors                       0.00

  Discarded errors                     0.00

  Ignored errors                       0.00

But I don't see any "T" operations in my text or avro file or Kafka topic.

Maybe I need to use a special parameter or option.

So far I am using default "prop" and "prm" files and can replicate DML or DDL like adding/removing a column for a table.

But no truncates are coming through.

My source is Oracle 12.1.0.2 and OGG 12.2.0.1 with the latest psu.

The destination is OGG for BD 12.3.0.1 with HDFS, Flume and Kafka.

Thanks,

Gleb

This post has been answered by K.Gan on Mar 20 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2017
Added on Mar 20 2017
12 comments
1,387 views