My Oracle Support Banner

OGG replicate fails with ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option (Doc ID 2562893.1)

Last updated on AUGUST 20, 2019

Applies to:

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

Symptoms

Mapping an alter table exchange partition statement in replicate

The resulting DDL statement in replicat failed with:
ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

The SQL that replicate tried to apply seems to have been duplicated after mapping


Before mapping:
DDL found, operation [ALTER TABLE snapshot_account EXCHANGE PARTITION SNAPSHOT_ACCOUNT_LT_63 WITH TABLE wk_snapshot_account WITHOUT VALIDATION (size 121)].

After:
DDL is of mapped scope, after mapping new operation [ALTER TABLE snapshot_account EXCHANGE PARTITION SNAPSHOT_ACCOUNT_LT_63 WITH TABLE "STG_COLL_FUSE"."WK_SNAPSHOT_ACCOUNT" WITHOUT VALIDATION "STG_COLL_FUSE".WK_SNAPSHOT_ACCOUNTALTER TABLE snapshot_account EXCHANGE PARTITION SNAPSHOT_ACCOUNT_LT_63 WITH TABLE "STG_COLL_FUSE"."WK_SNAPSHOT_ACCOUNT" WITHOUT VALIDATION (size 313)].


Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.