How To REPLICATE 'DROP PUBLIC SYNONYM '
(Doc ID 2066690.1)
Last updated on FEBRUARY 12, 2019
Applies to:Oracle GoldenGate - Version 18.104.22.168.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
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 , commit SCN  instance [ (1)], DDL seqno , marker seqno .
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.
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
|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'|