How To REPLICATE 'DROP PUBLIC SYNONYM '
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms