How to skip long running transactions in goldengate ?
GGSCI> send extract ENTNEW, showtrans
Sending SHOWTRANS request to EXTRACT ENTNEW ...
Oldest redo log file necessary to restart Extract is:
Redo Log Sequence Number 6, RBA 2239791
-----------------------------------------------------------
XID: 1.8.209025
Items: 0
Extract: ENTNEW
Redo Thread: 1
Start Time: 2015-26-22:00:10:06
SCN: 0.2239791 (2239791)
Redo Seq: 6
Redo RBA: 1470
Status: Running
use following command to skip long running transaction in goldengate
we use XID to skip transactions
GGSCI > send extract ENTNEW, skiptrans 1.8.209025
Thank you
NIKHIL TATINENI
Oracle in Memory _______
GGSCI> send extract ENTNEW, showtrans
Sending SHOWTRANS request to EXTRACT ENTNEW ...
Oldest redo log file necessary to restart Extract is:
Redo Log Sequence Number 6, RBA 2239791
-----------------------------------------------------------
XID: 1.8.209025
Items: 0
Extract: ENTNEW
Redo Thread: 1
Start Time: 2015-26-22:00:10:06
SCN: 0.2239791 (2239791)
Redo Seq: 6
Redo RBA: 1470
Status: Running
use following command to skip long running transaction in goldengate
we use XID to skip transactions
GGSCI > send extract ENTNEW, skiptrans 1.8.209025
Thank you
NIKHIL TATINENI
Oracle in Memory _______