Oracle GoldenGate - gg21: Initial Load of 100GB Table Failing

Issue: The initial load of a large Oracle table (100GB, 673,009,786 rows) is failing when attempting to extract and capture data into a trail file on a Windows server using Oracle GoldenGate (version 21).

Current Approach:

• The process involves capturing/extracting data into a trail file.
• Attempted to slice the table using SQLPREDICATE with a "WHERE COLUMN_NAME = ??" clause.
• The current extraction speed is approximately 800 rows per second.

Challenges:

• At the current speed, the extraction process would take days to complete.
  • thus, High risk of failure due to:
    • Network issues
    • OCI Error ORA-01555: snapshot too old
    • Other unforeseen errors

Request for Recommendations: