My Oracle Support Banner

Goldengate : File To Database Utility - Initial Load Techniques (Doc ID 1457989.1)

Last updated on MARCH 12, 2021

Applies to:

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


GoldenGate Initial Load: Loading Data from File To Database Utility

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 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.


The document discusses the method of performing an initial-load using a database bulk-load load utility by using an initial-load Extract to extract the data from the source tables and write them to an external file in ASCII format. The file then can be read by a database utility, specifically:

During the initial load, the change synchronization Extract/Replicat groups perform the extraction and apply of incremental changes that are then reconciled with the results of the load. 


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
 Configuration Parameters
 Extract Parameters
  Replicat Parameters
 Performing an Initial Data-Load Using File to Database Utilty method
 Initial-Load using File to Database Utility using Microsoft's BCP native utility
 Initial-Load using File to Database Utility using Oracle SQL*Loader utility
 Using SQLLoader to Perform an Initial Load from HP NonStop To Oracle Database
 Using SQLLoader to Perform an initial Load from Audited NonStop SQL/MP to Oracle Database

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