OGG Replicat Abends With ORA-14501 Object Is Not Partitioned Sql Alter Table <Schema>.<Table_Nanme> Add Partition <Partition_Name>
(Doc ID 2897846.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
Replicat is abended with below errors:
2022-08-21 03:31:18 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [14501],
ORA-14501: object is not partitioned SQL ALTER TABLE "<SCHEMA>"."<TABLE_NAME>"
ADD PARTITION <PARTITION_NAME>
VALUES LESS THAN (TO_DATE('20221001 000000', 'SYYYYMMDD HH24MISS', 'NLS_CALENDAR=GREGORIAN'))
TABLESPACE <TABLESPACE_NAME> /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
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 |
| Cause |
| Solution |