ogg中抽取进程的DDLOPTIONS ADDTRANDATA, REPORT 这个参数，有什么作用？
官方文档链接：
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters037.htm#GWURF451
Use ADDTRANDATA to:
Enable Oracle supplemental logging automatically for new tables created with a
CREATE TABLEstatement.Update supplemental logging for tables affected by an
ALTER TABLEstatement to add or drop columns.Update supplemental logging for tables that are renamed.
Update supplemental logging for tables where unique or primary keys are added or dropped.
REPORT | NOREPORTValid for Extract and Replicat (Oracle and Teradata). Controls whether or not expanded DDL processing information is written to the report file. The default of NOREPORT reports basic DDL statistics. REPORT adds the parameters being used and a step-by-step history of the operations that were processed.
评论
有用 0
