ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
hi experts,
when i run the below query it gives the error:
select operation,status,start_time,end_time from v$rman_status order by start_time;
error--
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2;
my current tablespace size is:
SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;
TABLESPACE_NAME BYTES_USED BYTES_FREE
------------------------------ ---------- ----------
TEMP1 2147483648 0
TEMP1 215220224 1.0522E+10
TEMP2 2147483648 0
TEMP2 2147483648 0
TEMP2 4294967296 0
SQL>
i already increase my temp tablespce size many times but again i face the same issue.
plz suggest what can i do to solve the issue.
regards
pirtesh ranjan