SQL Queries for Goldengate Replications

 

set linesize 200
set pagesize 100
set trimspool on

column table_owner                format a25 heading 'TABLE_OWNER'
column table_name                 format a35 heading 'TABLE_NAME'
column scn                        format 99999999999999999999 heading 'SCN'
column timestamp                  format a20 heading 'TIMESTAMP'
column supplemental_log_data_pk   format a8 heading 'LOG_PK'
column supplemental_log_data_ui   format a8 heading 'LOG_UI'
column supplemental_log_data_fk   format a8 heading 'LOG_FK'
column supplemental_log_data_all  format a8 heading 'LOG_ALL'

select table_owner,
       table_name,
       scn,
       timestamp,
       supplemental_log_data_pk,
       supplemental_log_data_ui,
       supplemental_log_data_fk,
       supplemental_log_data_all
from   dba_capture_prepared_tables;

set linesize 250
set pagesize 100
set trimspool on

column source_database        format a25 heading 'SOURCE_DB'
column source_object_owner    format a20 heading 'OWNER'
column source_object_name     format a35 heading 'OBJECT_NAME'
column source_object_type     format a12 heading 'OBJ_TYPE'
column instantiation_scn      format 99999999999999999999 heading 'INST_SCN'
column ignore_scn             format 99999999999999999999 heading 'IGNORE_SCN'
column apply_database_link    format a30 heading 'DB_LINK'
column source_root_name       format a25 heading 'SOURCE_ROOT'

select source_database,
       source_object_owner,
       source_object_name,
       source_object_type,
       instantiation_scn,
       ignore_scn,
       apply_database_link,
       source_root_name
from   dba_apply_instantiated_objects;