ADD TRANDATA fails with ORA-00957 duplicate column name (Doc ID 1478819.1)

Last updated on JULY 03, 2014

Applies to:

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

Symptoms

CREATE TABLE tcustmer
(
cust_code VARCHAR2(4),
name VARCHAR2(30),
city VARCHAR2(20),
state CHAR(2),
PRIMARY KEY (cust_code)
USING INDEX
);

GGSCI (rajesgov_us) 1> dblogin userid hr password hr
Successfully logged into database.

GGSCI (rajesgov_us) 2> add trandata hr.tcustmer, cols (cust_code, city)

2012-07-27 16:18:43 WARNING OGG-00706 Failed to add supplemental log group on
table HR.TCUSTMER due to ORA-00957: duplicate column name, SQL ALTER TABLE "HR"."TCUSTMER"
ADD SUPPLEMENTAL LOG GROUP "GGS_TCUSTMER_89682" ("CUST_CODE","CUST_CODE","CITY") ALWAYS /* GOLDENGATE_DDL_REPLICATION */.

 

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