When i have to include multiple schema name for the DDL filtering, i got the below error message
2014-12-25 07:58:48 ERROR OGG-00403 There can be only one DDL filtering statement. If DDL filter is long, use ampersand (&) sign to continue it on another line.
2014-12-25 07:58:48 ERROR OGG-01668 PROCESS ABENDING.
2014-12-25 07:58:48 ERROR OGG-00403 There can be only one DDL filtering statement. If DDL filter is long, use ampersand (&) sign to continue it on another line.
2014-12-25 07:58:48 ERROR OGG-01668 PROCESS ABENDING.
then i have modified like below. Below are the different example on how to include multiple schema and how to restrict the filtering in the EXTRACT for the Golden Gate.
Ex#1 - Including all the schema with all type of objects;
DDL INCLUDE MAPPED OBJNAME DISCOVER.* INCLUDE MAPPED OBJNAME RESEARCH.* INCLUDE MAPPED OBJNAME LOAD.* INCLUDE MAPPED OBJNAME TEST.* INCLUDE MAPPED OBJNAME EVENT.* INCLUDE MAPPED OBJNAME FAST.*;
-- All the schema DDLReplication for TABLES ONLY
DDL INCLUDE MAPPED OBJNAME DISCOVER.* INCLUDE MAPPED OBJNAME RESEARCH.* INCLUDE MAPPED OBJNAME LOAD.* INCLUDE MAPPED OBJNAME TEST.* INCLUDE MAPPED OBJNAME EVENT.* INCLUDE MAPPED OBJNAME FAST.*,OBJTYPE 'TABLE';
EX#2 - Including all the object, Except the exclusion specified below.
DDL INCLUDE MAPPED &
EXCLUDE INSTR 'drop partition' &
EXCLUDE OBJTYPE 'TRIGGER' &
EXCLUDE OBJTYPE 'INDEX' &
EXCLUDE OBJTYPE 'CONSTRAINT' &
EXCLUDE INSTRWORDS 'ALTER TABLE "DROP"' &
EXCLUDE INSTR 'DROP TABLE'
EX#3 - Excluding the DDL for MV's & MV LOG's
DDL INCLUDE MAPPED, EXCLUDE OBJTYPE 'SNAPSHOT', EXCLUDE OBJTYPE 'SNAPSHOT LOG'
)#) https://imgur.com/a/WWAh1s6 https://imgur.com/a/UwU2dLa https://imgur.com/a/35TjSSB https://imgur.com/a/izzobMP http://e9rdddoht2.dip.jp http://49pxjhfe34.dip.jp http://7kuizh3t6t.dip.jp
ReplyDeleteEmperor Casino | Shootercasino
ReplyDeleteEmperor Casino 바카라 사이트 is your premier online casino. We provide all the fun of an authentic casino 제왕카지노 experience. We have over 1700 games and we have the best 온카지노