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 18.104.22.168.3 and later
Information in this document applies to any platform.
**Disclaimer:** This KM article may include the following abbreviations:
GG -- Oracle GoldenGate
NMS - Oracle Network Management System
On : 22.214.171.124.3 version, Install / Upgrade
NMS Replication failed for NMS
User have configured OUA 126.96.36.199.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 , 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.
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