Solved

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

Posted on 2004-08-23
1
1,683 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 Database creation fails 5 50
Join SQL view with APEX item as the join condition 4 49
querying by the sum of a column in decimal 7 57
oracle 11g 23 51
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now