在擷取中檢視 DDL 報表

「摘錄」報告會列出下列項目：

每個擷取之 DDL 作業的整個語法、開始與結束 SCN、Oracle 執行處理、DDL 序號 (從歷史記錄表格的 SEQNO 資料欄) 以及作業大小 (位元組)。
後續項目，顯示如何將處理條件套用至作業，例如字串替代或 INCLUDE 和 EXCLUDE 篩選。
另一個項目，顯示作業是寫入歷程檔或排除。

從 Extract 報表取得的下列摘錄顯示包含的作業和排除的作業。包含的作業有報表訊息，但排除的作業沒有報表訊息。

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].