Solved

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

Posted on 2004-08-23
1
1,686 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 125 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle 12c patching 1 81
passing parameters to sql script oracle 4 41
How to free up undo space? 3 40
exp/imp 25 73
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
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…

770 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