You are configuring a multi-master DDL replication environment. To prevent looping of DDL
statement like CREATE TABLE (….), the best solution is______.
A.
Include the tranlogoptions (exclude user) parameter in each Extract parameter file
B.
Use the add FILTERTABLE command at the GGSCI prompt
C.
Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping
D.
This feature is not supported in GoldenGate 10.
Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
C
The correct id D.
I think A is better because the OPTYPE can only be CREATE, ALTER, RENAME. ‘CREATE TABLE’ can only used with INSTR, not OPTYPE
Ans: A
Example – TRANSLOGOPTIONS EXCLUDEUSER ggsrep