Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User416084Mar 18 2013 — edited Mar 19 2013

Hi Team,

I have created the temporary tablespace TEMP2 and assigned it to tablespace group and made it as default temporary tablespace.
After that I am getting this error
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP2

Before that I have only one tablespace TEMP and no group and I was not facing this error. After creating TEMP2 and tablespace group I am facing this error. Please let me know how to solve this issue. I have got lot of space in first TEMP tablespace.

SQL> SELECT * FROM dba_tablespace_groups;

GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_TS_GROUP TEMP
TEMP_TS_GROUP TEMP2

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2013

Added on Mar 18 2013

#error, #general-database-discussions

17 comments

2,070 views