truncate command is not passed from replicate to extract (Doc ID 3066610.1)

Last updated on JANUARY 07, 2025

Applies to:

Symptoms

truncate command is not passed from replicate to extract

Customer is operating in the following environment.
A database(extract) => B database(replicat) => C database(extract) => D database(replicat)

truncate command performed in A is passed to B,
but the truncate command is not passed from B to C, and errors OGG-00538, OGG-06507, and OGG-06509 occur.

2025-01-06 18:17:09  INFO    OGG-00538  Metadata not invalidated for "<SCHEMA_NAME>".TEST because of TRUNCATE.
2025-01-06 18:17:09  INFO    OGG-06507  MAP (TABLE) resolved (entry <SCHEMA_NAME>.TEST): TABLE "<SCHEMA_NAME>"."TEST".
2025-01-06 18:17:09  INFO    OGG-06509  Using the following key columns for source table <SCHEMA_NAME>.TEST: <COLUMN_NAME>.

Already using the following DDL option

-- DDL Transaction Option
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
GETTRUNCATES

Changes

none

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.