Replicat fails with OGG-00519 ORA-02149 for drop interval partition with system generated name.
(Doc ID 1954807.1)
Last updated on DECEMBER 28, 2020
Applies to:
Oracle GoldenGate - Version 11.2.1.0.3 to 12.1.3.0.0 [Release 11.2 to 12.1]Information in this document applies to any platform.
Symptoms
Replicat fails with OGG-00519 ORA-02149 for drop interval partition with system generated name.
alter table <schema>.<table> drop partition <partition name> UPDATE GLOBAL INDEXES ;
2014-12-09 10:07:27 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [2149], ORA-02149: Specified partit ion does not exist SQL alter table <schema>.<table> drop partition <partition name> UPDATE GLOBAL INDEXES /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |