DDL Replication for CREATE TABLE statement Fails by OGG-519 and ORA-14020
(Doc ID 2882408.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
When enabling DDL replication, Replicat process may be abended due to OGG-00519 and ORA-14020 when replicating "CREATE TABLE" statemet.
2022-07-04T10:50:25.615+0900 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, <Replicat>.prm: Fatal error executing DDL replication: error [Error code [14020], ORA-14020: this physical attribute may not be specified for a table partition
Changes
This problem may happen when following all conditions are satisfied
- DDL replictaion is enable
- "CREATE TABLE" statement is replicated
- "CREATE TABLE" statement includes "READ WRITE" or "READ ONLY" caluses
- Source Database is Oracle Database 12.2 or above
- Target Database is Oracle Database 12.1 or below
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 |