index
Moderators: chulett, rschirm, roy
index
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"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 wrote:No luck, Any other thoughts.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What happened to "no luck"?laxmi_etl wrote:Thanks for your concern.
I selected Index mode as maintanence and disable constraints true for the write mode append.
It solved my problem.
Thanks
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.