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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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.

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
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.