Focal Point
How to perform "DIRECT LOAD" from Data Migrator to Oracle?

This topic can be found at:

June 04, 2008, 05:33 PM
How to perform "DIRECT LOAD" from Data Migrator to Oracle?
I am being requested by my DBA to use Direct Load "To reduce archive logs generation – we will need to use direct load option."

I have changed the properties of the target to "Bulk Load utility via a Disk File" With the Direct Path Load option set to yes

Is this how I set DM for a direct load to SQL loader or is there something else I need to do?
June 12, 2008, 11:25 AM
Hi Morgan,

Has this issue been resolved? The following online document may be of interest:

Specifying Data Target Options
See -Oracle Target Bulk Load Options

Hope this helps. Smiler



Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
June 13, 2008, 07:09 AM

What release of Data Midrator is this avaliable in?

June 13, 2008, 10:05 AM
Support for ORACLE SQL*Loader Direct Path has always been available in DataMigrator, and in predecessor products back to Release 3.3.