在提取中查看 DDL 报告

“提取”报告列出以下内容：

每个捕获的 DDL 操作的整个语法、开始和结束 SCN、Oracle 实例、DDL 序列号（来自历史记录表的 SEQNO 列）以及操作的大小（字节）。
显示如何将处理条件应用于操作的后续条目，例如字符串替换或 INCLUDE 和 EXCLUDE 过滤。
显示操作是写入到线索还是排除的另一个条目。

以下摘录摘自“提取”报表，其中显示包括的操作和排除的操作。包含的操作存在报表消息，但不包含排除的操作。

2011-01-20 15:11:41  GGS INFO
2100  DDL found, operation
     [create table hr.employees
     (empId number (10) not null,
      Phone Number number,
      Designation varchar2(100),
      Date date,
      primary key (empId))],
 start SCN [1186754], commit SCN [1186772] instance [test11g (1)], DDL seqno [4134].

2011-01-20 15:11:41  GGS INFO     2100  DDL operation included [INCLUDE OBJNAME employees*], optype [CREATE], objtype [TABLE], objname [QATEST1.EMPLOYEES].

2011-01-20 15:11:41  GGS INFO     2100  DDL operation written to extract trail file.

2011-01-20 15:11:42  GGS INFO     2100  Successfully added TRANDATA for table with the key, table [QATEST1.EMPLOYEES], operation [ALTER TABLE "QATEST1"."EMPLOYEES" ADD SUPPLEMENTAL LOG GROUP "GGS_EMPLOYEES_53475" (MYID) ALWAYS  /* GOLDENGATE_DDL_REPLICATION */ ].

2011-01-20 15:11:43  GGS INFO     2100  DDL found, operation [create table EMPLOYEESTemp (
    vid varchar2(100),
    someDate date,
    primary key (vid)) ],
start SCN [1186777], commit SCN [1186795] instance [test11g (1)], DDL seqno [4137].

2011-01-20 15:11:43  GGS INFO     2100  DDL operation excluded [EXCLUDE OBJNAME EMPLOYEESTemp OPTYPE CREATE], optype [CREATE], objtype [TABLE], objname [QATEST1.EMPLOYEESTEMP].