Oracle Database Discussions

Hi, Everyone,

I am using oracle 11.1.0.6 version & OS is windows server R2 and i am trying to run a query which is using oracle "CORR function". i am getting the below error.

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
unable to extend temp segment by %s in tablespace %s"
*Cause: Failed to allocate an extent of the required number of blocks for
a temporary segment in the tablespace indicated.
*Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.

After searching various resources i tried to add a datafile by doing this:


ALTER TABLESPACE TEMP ADD TEMPFILE
'D:\oradata\dw\Temp03.dbf' size 30720M reuse autoextend on next 100M maxsize unlimited;

But still i get the same error as above. the query i am running is as follows :

INSERT INTO UNPVT_USM_DR_E0322
SELECT A.pr_id, A.NR,
B.NR AS col,
corr(A.n,B.m) val
FROM UNPVT_USM_DRPRE1_E0322 A, UNPVT_USM_DRPRE2_E0322 B
where a.col = b.col
GROUP BY A.PR_ID, A.NR,B.NR;



Could anyone please help me!!!!! How do i overcome this error!!!

Thanks