DDL Extract abends with "Could not add TRAN DATA for table, error [ORA-30567: name already used by an existing log group" for alter table rename ddl (Doc ID 1672192.1)

Last updated on MAY 15, 2014

Applies to:

Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When a table rename is done, extract capturing the ddls and using DDLOPTIONS ADDTRANDATA fails with below error

ALTER TABLE  OLTXNJRLTB RENAME TO  SOJ20140511

2014-05-12 01:15:13  ERROR   OGG-01489  Could not add TRAN DATA for table, error [ORA-30567: name already used by an existing
log group SQL ALTER TABLE "ECTON"."SOJ20140511" ADD SUPPLEMENTAL LOG GROUP "GGS_343693" ("OLCENSEQ") ALWAYS  
/* GOLDENGATE_DDL_REPLICATION */], error code [30567], operation [ALTER TABLE "ECTON"."SOJ20140511" ADD SUPPLEMENTAL LOG
GROUP "GGS_343693" ("OLCENSEQ") ALWAYS  /* GOLDENGATE_DDL_REPLICATION */ (size 127)].

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms