Goldengate : Direct Bulk Load to SQL*Loader - Initial Load Techniques (Doc ID 1461851.1)

Last updated on AUGUST 26, 2021

Applies to:

Purpose

GoldenGate Initial Load: Loading Data with a Direct Bulk Load to SQL*Loader

The note discusses how to configure the necessary initial-load processes and parameters, and it provides an example that illustrates the technique.

This document should be read in conjunction with the Primary Note Note: 1311707.1 Primary Note for Oracle GoldenGate: Initial Load Techniques.

Also, refer to the Oracle© GoldenGate Windows and UNIX Administrator’s Guide, chapter titled Running an initial data load, for detailed information about all initial load methods.

For information regarding SQL*Loader, refer to the Oracle Database Documentation: Oracle® Database Utilities

Scope

This method is only valid to be used with Oracle's SQL*Loader utility.

This is the fastest method to load Oracle database data with GoldenGate.

An initial-load Extract extracts the data from the source records and sends them directly to an initial-load Replicat TASK. The task is started directly by the Manager and does not require a collector process or file.

The initial-load Replicat task inferfaces with the SQL*Loader API to load the data as direct-path bulk load.

The port used by the delivery process may be controlled using the DYNAMICPORTLIST Manager parameter.

Details

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