index

[laxmi_etl]

My question is this

I am reading data from one table which is in x database and appending data to the oracle database this table is a partitioned table.
so its not allwoing me to choose index mode.when i try to run the job
its is giving the below error.

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

Oracle_Enterprise_12,0: The system(sqlldr rdw90_dm/change@rdwtest CONTROL=ora.602200.567189.0.ctl
LOG=ora.602200.567189.0.log
BAD=ora.602200.567189.0.log.bad SILENT=header PARFILE=ora.602200.567189.0.par) failed;
see the log file for the Oracle specific message.
Oracle_Enterprise_12,0: The runLocally() of the operator failed.
Oracle_Enterprise_12,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

what is the solutions for this.

Thanks

[ray.wurlod]

Add an index option (in the Oracle Enterprise stage) or drop indexes, recompile and rerun.

Get into the habit of using meaningful stage and link names.

[laxmi_etl]

No luck, Any other thoughts.

[DSguru2B]

Did you actually try try searching on your error message
I found a few hits, like thisfor instance.

[ray.wurlod]

No luck, Any other thoughts.

"No luck" may mean that you didn't even try it - even with my RMM stage operational I have no way of knowing that. Explain what you tried, what results obtained and whether these results were different from those obtained previously.

[laxmi_etl]

Thanks for your concern.

I selected Index mode as maintanence and disable constraints true for the write mode append.

It solved my problem.

Thanks

[DSguru2B]

Great, now onto the next step, Mark the post as "Resolved."

[ray.wurlod]

Thanks for your concern.

I selected Index mode as maintanence and disable constraints true for the write mode append.

It solved my problem.

Thanks

What happened to "no luck"?

[laxmi_etl]

Thanks Ray..