My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2020

Applies to:

Oracle GoldenGate - Version 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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.