To prevent looping of DDL statement like CREATE TABLE (….), the best solution is______.

You are configuring a multi-master DDL replication environment. To prevent looping of DDL
statement like CREATE TABLE (….), the best solution is______.

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


franciscotmjr

franciscotmjr

The correct id D.

Tai

Tai

I think A is better because the OPTYPE can only be CREATE, ALTER, RENAME. ‘CREATE TABLE’ can only used with INSTR, not OPTYPE

S De

S De

Ans: A

Example – TRANSLOGOPTIONS EXCLUDEUSER ggsrep