Oracle Enterprise Loader - Direct vs. Conventional Path

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sridharvg
Participant
Posts: 17
Joined: Wed Jul 19, 2006 3:19 am
Location: Hyderabad, India
Contact:
Contact sridharvg

Oracle Enterprise Loader - Direct vs. Conventional Path

Post by sridharvg »

Can anyone tell me about the Direct and Conventional paths used in Oracle loader and also how are these related to indexes.
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Direct path load ignores the index while loading data when its finished it has to do maintainence work make the index usable or rebuild the indexes entirely. While conventional path load uses the general sqlldr to insert records to the oracle table keeping indexes intact.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Oracle Enterprise Loader

Post by chulett »

sridharvg wrote:Can anyone tell me about the Direct and Conventional paths used in Oracle loader and also how are these related to indexes.
Sure, your DBA. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
sridharvg
Participant
Posts: 17
Joined: Wed Jul 19, 2006 3:19 am
Location: Hyderabad, India
Contact:
Contact sridharvg

Post by sridharvg »

Thanks a lot guys.
Top
Post Reply

Return to “General”