Page 1 of 1

Oracle read error

Posted: Mon Feb 25, 2008 6:47 pm
by just4u_sharath
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
.

Posted: Mon Feb 25, 2008 7:25 pm
by ray.wurlod
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.