preclude direct parallel loading

ravij · Post by **ravij** » Thu Mar 10, 2011 5:07 am

Hi,

We are loading the data from dataset to Ora db(10g) table with WriteMethod as Upsert. The job got aborted due to the below error.

oraDForecastMonthly: Indexes on table xxx.D_FORECAST_MONTHLY_VERSION' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.

I searched in the forum, and found some solution to use Rebuild option, but that is possible only when you use WriteMethod as Load, but I want to use Upsert in my ora stage.
Can anyone please help me in this regard.
Appreciate your help
thanks in advance.

GJ_Stage · Post by **GJ_Stage** » Thu Mar 10, 2011 5:51 am

Add parameter : APT_ORACLE_LOAD_OPTIONS
value is : OPTIONS(SKIP_INDEX_MAINTENANCE=TRUE)
in your job and then try.