1. Microservices Architecture Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Viewing DDL Report Information
  6. Viewing DDL Reporting in Replicat

Viewing DDL Reporting in Replicat

The Replicat report lists:

  • The entire syntax and source Oracle GoldenGate SCN of each DDL operation that Replicat processed from the trail. You can use the source SCN for tracking purposes, especially when there are restores from backup and Replicat is positioned backward in the trail.

  • A subsequent entry that shows the scope of the operation (MAPPED, UNMAPPED, OTHER) and how object names were mapped in the target DDL statement, if applicable.

  • Another entry that shows how processing criteria was applied.

  • Additional entries that show whether the operation succeeded or failed, and whether or not Replicat applied error handling rules.

The following excerpt from a Replicat report illustrates a sequence of steps, including error handling:
2023-09-06 18:50:13 INFO OGG-01487 DDL found, operation [create table hr.employees(a int primary key, b int) (size 45)], start SCN [3344441], commit SCN [3344461] instance [ (1)], DDL seqno [0], marker seqno [0].
2023-09-06 18:50:13 INFO OGG-10451 DDL operation included [INCLUDE MAPPED], optype [CREATE], objtype [TABLE], catalog "CDBA_PDB01", objowner "HR", objname "EMPLOYEES".
2023-09-06 18:50:13 INFO OGG-01487 DDL found, operation [create table HR.EMPLOYEES_BAK (a int primary key, b int) (size 45)], start SCN [3344467], commit SCN [3344486] instance [ (1)], DDL seqno [0], marker seqno [0].
2023-09-06 18:50:13 INFO OGG-10452 DDL operation excluded [EXCLUDE OBJNAME HR.EMPLOYEES_BAK], optype [CREATE], objtype [EMPLOYEES_BAK], catalog "CDBA_PDB01", objowner "HR", objname "EMPLOYEES_BAK".