You can use the Oracle SQL*Loader to process and load initial-state data into an Oracle database. This process is supported in two modes: file mode and stream mode:
In file mode, initial-state data is received by the Event Replicator Target Adapter and stored in a DAT file prior to being sent to the Oracle SQL*Loader for processing. For more information about the DAT files created as part of this processing, read Processing Output
In stream mode, initial-state data is received by the Event Replicator Target Adapter and stored in memory prior to being sent to the Oracle SQL*Loader for processing. No DAT files are created.
Note:
The Oracle SQL*Loader can only be used with the Event Replicator Target Adapter to load
initial-state data; it cannot be used for transactional data.
This document covers the following topics:
The following prerequisites must be met before the Oracle SQL*Loader can be used to load initial-state data to an Oracle database, via the Event Replicator Target Adapter.
The Oracle utilities supporting the Oracle SQL*Loader must be installed on the same machine as the Event Replicator Target Adapter.
The Oracle Net Manager must be installed and configured if Oracle is running on a different machine than the Event Replicator Target Adapter.
If file mode is requested, be sure there is enough space to accommodate the DAT files that will be created by this processing.
To enable Oracle SQL*Loader initial-state processing:
Using the Administration tool, configure a target definition for your Oracle database. For more information, read Configuring Target Definitions for Event Replicator Target Adapter.
Using the Administration tool, create a specific target processing option definition for your Oracle database. For this definition you must:
Select the Use Loader check box (check it).
Provide a value for the Path field, identifying the full path of the Oracle SQL*Loader executable.
Specify the rows option in the
Options field, specifying the number of rows
you want to read from the data file before a data save is performed by the
SQL*Loader.
Save the target processing option definition with the same name as the target definition you created in Step 1.
You should also evaluate and optionally specify values for the following fields in this target processing option definition:
Service, which specifies the Oracle database service name that should be used with the Oracle SQL*Loader.
Environment File, which specifies the file name containing the Oracle environment variables that should be used with the Oracle SQL*Loader.
Use Stream, which indicates whether processing should be performed in stream mode or not.
For more information about these options, read Specifying Target Database Processing Option Definitions.
When all processing options are specified, start initial-state processing, directing the output to the Event Replicator Target Adapter via a GFFT you created (using the Data Mapping Tool or the Adabas Event Replicator Subsystem) for the Oracle database.
For more information on this, read Requesting Initial-State Data.
The Event Replicator Target Adapter will collect the initial-state records and send them to the Oracle SQL*Loader to be loaded to your Oracle database.
Note:
Some errors might prevent the Oracle SQL*Loader from
restoring primary and foreign keys, indexes, and the unique index of tables. We
recommend that you examine the Oracle SQL*Loader log files to determine if such
an error occurred. For more information, read
Processing
Output.
The output from this processing includes:
Various Oracle SQL*Loader files used for its processing
Oracle SQL*Loader log files from the processing
DAT files containing the initial-state data received by the Event Replicator Target Adapter prior to being processed by the Oracle SQL*Loader.
All output files are written to the \logs subdirectory of your Event Replicator Target Adapter installation
This section covers the following topics:
The Oracle SQL*Loader log files are stored in files that have names in the format xxxx_yymmdd_hhmmss.log, where xxxx is the table name, yymmdd is the date of the log file, and hhmmss is the time the log file was last written to.
We recommend that you review this log file carefully to ensure that the Oracle SQL*Loader had no problems restoring primary and foreign keys, indexes, or the unique index of tables.
DAT files are only created by the Event Replicator Target Adapter if you have selected Oracle SQL*Loader processing in file mode. If you select stream mode, these files are not created. These files can take a good deal of space, so make sure that there is enough space to accommodate them and be sure to manually delete them when initial-state processing has completed successfully.
The format of the DAT file names is xxxx_yymmdd_hhmmss.dat, where xxxx is the table name, yymmdd is the date of the DAT file, and hhmmss is the time the DAT file was last written to.