My Oracle Support Banner

How to limit OGG Adapter table generating .dsv outputs upto 8GB (Doc ID 2643755.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate Application Adapters - Version 12.3 and later
Information in this document applies to any platform.

Goal

One table generates .dsv outputs upt to 8GB. Example as below:

-rwxrwxrwx 1 oinfprd2 oinfprd2 8218882845 Jan 29 10:25 pump_NW_RPT_EXT_CASH_FLOW_PRJ_2020-01-29_01-11-57_00379_data.dsv
-rwxrwxrwx 1 oinfprd2 oinfprd2 8219662403 Jan 29 10:26 pump_NW_RPT_EXT_CASH_FLOW_PRJ_2020-01-29_00-42-07_00378_data.dsv

The large sizes makes downstream process hard to manage. Is there a way to split the outputs to smaller chunks?
 

Solution

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
Goal
Solution


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