How To REPLICATE 'DROP PUBLIC SYNONYM '

(Doc ID 2066690.1)

Last updated on JULY 17, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms