June 04, 2008, 05:33 PM
MorganHow 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
KerryHi Morgan,
Has this issue been resolved? The following online document may be of interest:
Specifying Data Target OptionsSee -Oracle Target Bulk Load Options
Hope this helps.
Cheers,
Kerry
June 13, 2008, 07:09 AM
alrubyKerry,
What release of Data Midrator is this avaliable in?
Thanks,
Allen.
June 13, 2008, 10:05 AM
ClifSupport for ORACLE SQL*Loader Direct Path has always been available in DataMigrator, and in predecessor products back to Release 3.3.