error while extracting the data from oracle enterprise stage

[pongal]

here i am using the following query to extract the data from oracle9i database through Oracle Enterprise stage

##W TCOS 000049 23:26:35(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TDOR 000062 23:26:39(001) <Oracle_Enterprise_12> Column HOURS floating point decimal is not fully supported; adjusting the scale.
##W TFIP 000022 23:26:39(005) <Oracle_Enterprise_12> When checking operator: When binding output interface field "Contractor_ID" to field "Contractor_ID": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
##W TFIP 000022 23:26:39(006) <Oracle_Enterprise_12> When checking operator: When binding output interface field "PONUM" to field "PONUM": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
##W TFOP 000062 23:28:50(000) <Oracle_Enterprise_12,0> Column HOURS floating point decimal is not fully supported; adjusting the scale.
>##E TFOP 000212 23:28:50(001) <Oracle_Enterprise_12,0> Oracle call failed; sqlcode = -1652; message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01>.
>##E TFOP 000176 23:28:50(002) <Oracle_Enterprise_12,0> Array Fetch failed for: SELECT

>TS.PRID,

>TS.PRISADJUSTMENT,

>SP.NAME,

>NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME) Contractor_ID,

>SR.FULL_NAME,

>'PO'||NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME) PONUM,

>SUM(TE.PRACTSUM/60/60) hours,

>TP.PRSTART,

>TP.PRFINISH

>FROM

>PRTIMEENTRY TE,

>PRTIMESHEET TS,

>PRTIMEPERIOD TP,

>SRM_RESOURCES SR,

>XDM_CDF_SRM_RESOURCES X,

>PRASSIGNMENT PA,

>PRTASK PT,

>PRJ_PROJECTS PP,

>SRM_PROJECTS SP

>WHERE

>TE.PRASSIGNMENTID = PA.PRID AND

>TE.PRTIMESHEETID = TS.PRID AND

>TS.PRRESOURCEID = SR.ID AND

>SR.ID = X.PARENT_ID (+) AND

>PA.PRTASKID = PT.PRID AND

>PT.PRPROJECTID = PP.PRID AND

>PP.PRID = SP.ID AND

>SR.PERSON_TYPE = 301 AND

>TS.PRSTATUS = 4

>GROUP BY

>TS.PRID,

>TS.PRISADJUSTMENT,

>NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME),

>SR.FULL_NAME,

>'PO'|| NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME),

>SP.NAME,

>TP.PRSTART,

>TP.PRFINISH.

>##E TFOP 000089 23:28:50(003) <Oracle_Enterprise_12,0> The runLocally() of the operator failed.
##I TFOP 000094 23:28:50(004) <Oracle_Enterprise_12,0> Output 0 produced 0 records.
>##E TFPM 000040 23:28:50(005) <Oracle_Enterprise_12,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E TFPM 000338 23:28:51(000) <main_program> Unexpected exit status 1
>##E TFSR 000011 23:28:56(000) <main_program> Step execution finished with status = FAILED.
##I TCOS 000026 23:28:56(001) <main_program> Startup time, 0:11; production run time, 2:11.

what exactly the problem and where i need to fix it.... i mean, is it problem with database or do i need to take care anything in oracle enterprise stage ?

Thanks in advance
pongal

[ArndW]

Pongal,

you need to talk with your DBA about this, as the message states the process cannot allocated Oracle EXTENTS.

[jasper]

main thing you need to do is use datastage as it is meant. Why are you writing these complex queries in one stage.
Performance of your full job will be a lot better if you use one oracle-stage per table which you then join in datastage and also use the ds-aggregator.
This will also get you a better load balance between your DS and DB-server.