GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to fetch specific records from the trail file

edited May 20, 2013 11:59AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi,

We are troubleshooting the unique constraint errors as it is causing the replicat abending.  So we would like to fetch speciific update records of TWFA0090_TRN_QUEUE_TRKG from the below trail file.  Would you please guide me as how to get those records by using the logdump utility. 

=====

Reading /gghome/gg_EDW/product/11.2.0/dirdat/ddrq03/ep001350, current RBA 39965826, 773 recordsReport at 2013-05-20 14:51:54 (activity since 2013-05-20 14:51:35)From Table TFAADM.TWFA0040_HV_TB_QUEUE_TRKG to FGAPP.TWFA0040_HV_TB_QUEUE_TRKG:# inserts: 1# updates: 11# deletes: 0# discards: 0From Table TFAADM.TWFA0080_INT_RCV_QUEUE_TRKG to FGAPP.TWFA0080_INT_RCV_QUEUE_TRKG:# inserts: 0# updates: 3# deletes: 0# discards: 0From Table TFAADM.TWFA0090_TRN_QUEUE_TRKG to FGAPP.TWFA0090_TRN_QUEUE_TRKG:# inserts: 11# updates: 13# deletes: 0# discards: 1From Table TFAADM.TWFA0167_CSH_JRNL_STG to FGAPP.TWFA0167_CSH_JRNL_STG:# inserts: 734# updates: 0# deletes: 0# discards: 0~Suresh

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center