My Oracle Support Banner

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

Last updated on JUNE 05, 2019

Applies to:

Oracle GoldenGate - Version 10.0.0.0 to 11.2.1.0.3 [Release 10.0.0 to 11.2]
Information in this document applies to any platform.

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 Master Note Note: 1311707.1 Master 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.

NOTE:
Mapping and Data Transformation can be done by initial-load Extract or Replicat or both if required.

Details

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
Purpose
Scope
Details
 Configuration Parameters
 Extract Parameters
 Replicat Parameters
 Performing an Initial Data-Load Using a Direct Bulk Load to SQL*Loader
 Example: Initial-Load using a Direct Bulk Load to Oracle SQL*Loader
References

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