In my extraction job there are two oracle stages ouput of which is funneled and passed to other stages. I know from one oracle stage, no data will be outputted. when i run the job, the job aborted and below is the error message. Can you help me with this issue. From the below oracle stage no data is outputted
OraIliad_cap_pay_detls,0: Oracle call failed; sqlcode = -12801; message: ORA-12801: error signaled in parallel query server P004
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP01
.
Oracle read error
Moderators: chulett, rschirm, roy
-
just4u_sharath
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is not a DataStage problem.
Your Oracle instance has run out of space in your TEMP01 tablespace. Either clean up (drop) some old tables or have your Oracle DBA extend the TEMP01 tablespace.
Your Oracle instance has run out of space in your TEMP01 tablespace. Either clean up (drop) some old tables or have your Oracle DBA extend the TEMP01 tablespace.
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.