GG DDL History

on August 25, 2016 at 2:22 pm
Posted In: Oracle Golden Gate (Cat)

 

select METADATA_TEXT from ggs_admin.ggs_ddl_hist where ddltype = ‘CREATE’;

 

SEQNO

NOT NULL NUMBER

OBJECTID

NUMBER

DATAOBJECTID

NUMBER

DDLTYPE

VARCHAR2(130)

OBJECTNAME

VARCHAR2(400)

OBJECTOWNER

VARCHAR2(400)

OBJECTTYPE

VARCHAR2(130)

FRAGMENTNO

NOT NULL NUMBER

OPTIME

NOT NULL CHAR(19)

STARTSCN

NUMBER

METADATA_TEXT

NOT NULL VARCHAR2(4000)

AUDITCOL

VARCHAR2(80)

Use DDLOPTIONS ADDTRANDATA to:

◆ enable Oracle’s supplemental logging automatically for new tables created with a CREATE TABLE.
â—† to update supplemental logging for tables affected by an ALTER TABLE 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.
The default is: DDLOPTIONS ADDTRANDATA RETRYOP RETRYDELAY 10 MAXRETRIES 10

By default, truncate operations are not captured from the source or replicated to the target.

Use the HANDLECOLLISIONS and NOHANDLECOLLISIONS parameters to control whether or not Replicat tries to resolve duplicate-record and missing-record errors when applying SQL on the target.

CHCKPNTTABLE

CHCKPNTTABLE_LOX

CHKPTAB

CHKPTAB_LOX

GGS_DDL_COLUMNS

GGS_DDL_HIST

GGS_DDL_HIST_ALT

GGS_DDL_LOG_GROUPS

GGS_DDL_OBJECTS

GGS_DDL_PARTITIONS

GGS_DDL_PRIMARY_KEYS

GGS_DDL_RULES

GGS_DDL_RULES_LOG

GGS_MARKER

GGS_SETUP

GGS_STICK

GGS_TEMP_COLS

GGS_TEMP_UK

select METADATA_TEXT from ggs_admin.ggs_ddl_hist where DDLTYPE = ‘CREATE’ order by SEQNO