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