Why Discard File Shows - ORA-39726: Unsupported Add/drop Column Operation On Compressed Tables ? (Doc ID 2044784.1)

Last updated on AUGUST 17, 2015

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Goal

Why discard file shows the following error?:

Oracle GoldenGate Delivery for Oracle process started, group [name] discard file opened: 2015-08-11 10:53:31.936243
Current time: 2015-08-11 13:23:26
 Error text [Error code [39726], ORA-39726: unsupported add/drop column operation on compressed tables SQL alter table "yyy"."xxx" drop column test /* GOLDENGATE_DDL_REPLICATION */], operation [alter table "yyy"."xxx" drop column test (size 51)]
Operation failed at seqno 0 rba 5494


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms