Home » Developer & Programmer » JDeveloper, Java & XML » Temporary Tablespace
Temporary Tablespace [message #204089] Fri, 17 November 2006 13:54 Go to next message
Messages: 44
Registered: June 2006
I am unable to understand why I am getting ORA-1652: unable to extend temp segment by 256 in tablespace TEMP.

Harleen Flora
Re: Temporary Tablespace [message #204094 is a reply to message #204089] Fri, 17 November 2006 14:17 Go to previous message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Many database operations/code will require the dataset to be sorted. This sort is done in memory defined by SORT_AREA_SIZE. In most cases these operation may need a larger finite space for the sort segments (especially when you are doing multiple sorts). TEMP tablespace will be used for those sorting purposes.
If the allocated space is not enough, you will end up in the error.
Sometimes operations like index creations also need data to be sorted. Temporary segments are used for this (inside the tablespace used for index). After the sorting is done, the temporary segment is converted into an index segment.
More accurate and demonstrated information is available in documentation.
Please have a look.
Previous Topic: Parse XML Blob in PL/SQL
Next Topic: Java calling Oracle Update statement
Goto Forum:

Current Time: Fri Mar 24 23:54:54 CDT 2023