Goldengate : Direct Bulk Load to SQL*Loader - Initial Load Techniques
(Doc ID 1461851.1)
Last updated on AUGUST 26, 2021
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 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.
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 |