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

Posted on 2004-08-23
Medium Priority
Last Modified: 2013-12-11
I am moving an index to another tablespace using
alter index <indexname> rebuild tablespace <new tablsepace>;

The index segment size is 5 GB and temp tablespace is 2 GB.

I am getting the error:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Does it mean I need to increase my temp tablespace to at least  5 GB ?

Question by:grora
1 Comment

Accepted Solution

chedgey earned 500 total points
ID: 11879643

i am sorry but it is not that simple. The Temp space required is the space required for Oracle to calclulate the index entries, not the space required to store the index itself.

That means that you could require an additional 100K or an additional 10Gb. My recommendation would be to Rebuild the TEMP tablepsace large with AUTOEXTEND on witht eh NEXT extent value being quite large, say 500K to allow for large operations.

After you perform large operations like this you can always resize the tablespace back down to your normal operational level.



Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question