How to Rollover a OGG Flat File Adapter Output File Based On Timestamp In The Trail (Doc ID 1504448.1)

Last updated on JULY 17, 2017

Applies to:

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

Goal

We are using OGG Adapter Flat File writer and would like to rollover the output file daily based on the date timestamp change in the trail data itself. 

For example, we would like transactions from 21-OCT-2012 to be all in the same file and transactions from 22-OCT-2012 to be in the next file, etc.
 

Solution

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