Oracle Enterprise Loader - Direct vs. Conventional Path
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Wed Jul 19, 2006 3:19 am
- Location: Hyderabad, India
- Contact:
Oracle Enterprise Loader - Direct vs. Conventional Path
Can anyone tell me about the Direct and Conventional paths used in Oracle loader and also how are these related to indexes.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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 :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
Re: Oracle Enterprise Loader
Sure, your DBA.sridharvg wrote:Can anyone tell me about the Direct and Conventional paths used in Oracle loader and also how are these related to indexes.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers