Using APT_ORACLEAPT_ORACLE_LOAD_OPTIONS

prasad v · Post by **prasad v** » Mon Nov 22, 2010 6:19 am

hi

I am just refereing the datastage pdf's, and had doubt avout using the variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE) options.

If we use this it will skip the Index creation, when the index will be created to improve the retrieval performance for Busienss Users. orelse do we need to do this database level?

chulett · Post by **chulett** » Mon Nov 22, 2010 7:52 am

That particular option simply says to run a single-threaded direct path sqlldr session. It implies something about any indexes but doesn't "skip" anything. Have a chat with your DBA if you are unsure how sqlldr and those kind of options work.

GJ_Stage · Post by **GJ_Stage** » Thu Nov 25, 2010 6:08 am

If you this value (OPTIONS(SKIP_INDEX_MAINTENANCE=TRUE) then It will skip indexes while loading. It will enable the indexes automatically once loading got completed.