My Oracle Support Banner

How To REPLICATE 'DROP PUBLIC SYNONYM ' (Doc ID 2066690.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


have DDL replication turned on in your env

ddl include mapped, include optype publicsynonym exclude optype analyze, exclude instr 'create user', exclude instr 'alter user', exclude instr 'drop user'

you have tried adding the optype publicsynonym to see if you could get the drop public synonym to replicate. you are still getting that DDL is of UNMAPPED scope. The create public synonym replicates fine with this parameters

Symptoms

 The create public synonym replicated fine. But drop Public synonyms does not getting dropped on target . give below in report file of extract

2015-10-08 16:38:22  INFO    OGG-01487  DDL found, operation [DROP PUBLIC SYNONYM ORA_SYNONYM (size 32)], start SCN [14290076925666], commit SCN [14290076925675] instance [ (1)], DDL seqno [0], marker seqno [0].
2015-10-08 16:38:22  INFO    OGG-00487  DDL operation included [include unmapped objtype 'publicsynonym' objname public.*], optype [DROP], objtype [PUBLICSYNONYM], objowner [PUBLIC], objname [KRIS_SYNONYM].
2015-10-08 16:38:22  INFO    OGG-00497  Writing DDL operation to extract trail file.

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
 ddl include mapped, include objtype 'publicsynonym' objname public.* optype drop ,exclude optype analyze, exclude instr 'create user', exclude instr 'alter user', exclude instr 'drop user'
References


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