Extract abends with OGG-02297 This Is An Unsupported ALTER TABLE Statement For Table
(Doc ID 2728380.1)
Last updated on JULY 18, 2023
Applies to:
Oracle GoldenGate - Version 12.3.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
Oracle GoldenGate 19.1.0.0.4 extract configured for DML and DDL replication abends with the following error:
OGG-02297 This is an unsupported ALTER TABLE statement for table "<OWNER>"."<TABLE>".
Changes
Extract was configured for DDL reporting by adding DDLOPTIONS REPORT to the extract parameter file and restarting extract.
The following was then reported prior to the OGG-02297:
OGG-01487 DDL found, operation [ALTER TABLE <OWNER>.<TABLE> ADD ( <COLUMN> NUMBER DEFAULT <OWNER>.<SEQUENCE>.NEXTVAL )]
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 |