My Oracle Support Banner

DDL SQL Taking A Long Time To Execute In Golden Gate Source Database (Doc ID 2479670.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


When trying to add a sub partition to a table, it is taking over 5 minutes to complete.

"alter table <shema_name>.<table_name> modify
PARTITION "<partition_name>"
ADD SUBPARTITION "<partition_name>" VALUES LESS THAN (TO_DATE('11/29/2018','mm/dd/yyyy')) tablespace <tablespace_name>

While investigating, it was discovered that the  GG capture DDL query is running for a long time and is holding up the sub-partition sql.


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

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