My Oracle Support Banner

ORA-01430: Column Being Added Already Exists in Table SQL ALTER TABLE "NMS1REP"."<Table_Name>" ADD <Column_Name> VARCHAR2(30) (Doc ID 2709962.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.3 and later
Information in this document applies to any platform.

Goal

**Disclaimer:** This KM article may include the following abbreviations:

GG -- Oracle GoldenGate

NMS - Oracle Network Management System

On : 2.7.0.1.3 version, Install / Upgrade
NMS Replication failed for NMS

User have configured OUA 2.7.0.1.3 for NMS and when user upgraded NMS source database the replicate is failing with below error:
"2020-08-03 11:41:00 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [1430], ORA-01430: column being added already exists in table SQL ALTER TABLE "NMS1REP"."<Table_Name>" ADD <Column_Name> VARCHAR2(30) /* GOLDENGATE_DDL_REPLICATION */], no error handler present."

User have tried restarting the replicat multiple time but still the error persists.
The replicate was working fine prior to upgrade and the data was being replicated.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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