Which tables have changes in a GoldenGate trail file?

I use the following to identify which tables have changes recorded in a trail file, as well as how many changes each table has…

CMHLDECOMDB01:oracle:cmhecomd1:/u01/app/oracle/acfsmounts/ggate/oracle2/dirdat>strings -a r1000009 | grep ATGDB | sort | uniq -c
      6 ATGDB_CORE.DAS_ID_GENERATOR
  21873 ATGDB_CORE.DCSPP_ORD_ABANDON
  10937 ATGDB_CORE.DCS_USER_ABANDONED
CMHLDECOMDB01:oracle:cmhecomd1:/u01/app/oracle/acfsmounts/ggate/oracle2/dirdat>

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.