Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlldr & SKIP_INDEX_MAINTENANCE

509192Dec 30 2007 — edited Jan 2 2008
Hi
I am using Informatica to use sqlldr to load multiple files into a partitioned table A
DIRECT=TRUE &
PARALLEL=TRUE

Table A has indexes on it which have been made UNUSABLE through a script. (Dont want to drop and recreated them)

Through informatica I cannot set the parameter

SKIP_INDEX_MAINTENANCE=TRUE

Is there any method through which I can set it as an environment variable on Unix and pass it to sqlldr.

OS: HP UX
DB: 10g R2

Any help is appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2008
Added on Dec 30 2007
3 comments
2,469 views