Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    How to perform "DIRECT LOAD" from Data Migrator to Oracle?
Go
New
Search
Notify
Tools
Reply
  
How to perform "DIRECT LOAD" from Data Migrator to Oracle?
 Login/Join
 
Member
posted
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?
 
Posts: 4 | Registered: September 28, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
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

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Kerry,

What release of Data Midrator is this avaliable in?

Thanks,
Allen.
 
Posts: 4 | Registered: February 21, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
Support for ORACLE SQL*Loader Direct Path has always been available in DataMigrator, and in predecessor products back to Release 3.3.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    How to perform "DIRECT LOAD" from Data Migrator to Oracle?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.