Integrated Extract Cannot Be Altered with a Previous Timestamp (Doc ID 1485803.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

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.

 

Cause

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