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.
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.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.
Can anyone please help me in this regard.
Appreciate your help
thanks in advance.