sqlldr & SKIP_INDEX_MAINTENANCE
509192Dec 30 2007 — edited Jan 2 2008Hi
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.