Add Trandata Resulting ORA-32588 "supplemental logging attribute primary key exists" (Doc ID 3081460.1)

Last updated on APRIL 11, 2025

Applies to:

Symptoms

When user is trying add trandata for a table getting below error.

GGSCI> add trandata <SCHEMA_NAME>.<TABLE_NAME>

WARNING OGG-00706 Failed to add supplemental log group on table <SCHEMA_NAME>.<TABLE_NAME> due to ORA-32588: supplemental logging attribute primary key exists

SQL ALTER TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE, FOREIGN KEY) COLUMNS /* GOLDENGATE_DDL_REPLICATION */.

Changes

 User tried deleting and adding trandata but still facing the same issue.

Cause

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