Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2004-08-23
1
Medium Priority
?
1,724 Views
Last Modified: 2013-12-11
Hi,
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 ?

TIA,
Rakesh
0
Comment
Question by:grora
1 Comment
 
LVL 6

Accepted Solution

by:
chedgey earned 500 total points
ID: 11879643
Rakesh,

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.

Regards

Chedgey
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

877 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