Integrated Extract Cannot Be Altered with a Previous Timestamp (Doc ID 1485803.1)
Last updated on OCTOBER 28, 2016
Oracle GoldenGate - Version 22.214.171.124.1 and later Information in this document applies to any platform.
The Integrated extract could not be altered to start with a previous begin <timestamp>. When altering the IE extract with a previous timestamp, the extract will not capture the records.
Steps to reproduce the issue
1. Create table (sql\demo_ora_create.sql) or any table 2. Add Integrated Extract with BEGIN NOW statements and start it 3. Create workload (sql\demo_ora_insert.sql) or some DML's to the created table 4. See generated trail - it contains captured data 5. Stop Integrated Extract 6. Alter Integrated Extract with BEGIN YYYY-MM-DD HH:MI:SS to the time before Step 3. 7. Start Integrated Extract 8. See generated trail - it should contain data generated by step 3. But it doesn't.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms