Extract abends with OGG-02297 This Is An Unsupported ALTER TABLE Statement For Table
(Doc ID 2728380.1)
Last updated on FEBRUARY 04, 2021
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Oracle GoldenGate 126.96.36.199.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>".
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 )]
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