My Oracle Support Banner

DDL Statements for Public Synonym Is Not Captured When EXCLUDE ALL Is Specified In DDL Clause (Doc ID 2967721.1)

Last updated on OCTOBER 06, 2023

Applies to:

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

Symptoms

DDL replication is enabled in Capture process, and "EXCLUDE ALL" is specified in DDL clauses.

At this case, DDL statements for "Public Synonym" is not excluded as below, but Capture process does not capture DDL statements for "Public Synonym".

DDL INCLUDE ALL, EXCLUDE ALL OPTYPE DROP OBJTYPE 'PACKAGE';

Changes

"EXCLUDE ALL" is specified in DDL clause of Capture process.

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.