Database Administration (MOSC)

MOSC Banner

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2

edited Mar 5, 2014 12:00PM in Database Administration (MOSC) 18 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center