Solved

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

Posted on 2004-08-23
1
1,691 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

740 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