| Temporary Tablespace [message #204089] |
Fri, 17 November 2006 13:54  |
harleenflora
Messages: 44
Registered: June 2006
|
Member |
|
|
I am unable to understand why I am getting ORA-1652: unable to extend temp segment by 256 in tablespace TEMP.
Thanks,
Harleen Flora
|
|
|
|
| Re: Temporary Tablespace [message #204094 is a reply to message #204089] |
Fri, 17 November 2006 14:17  |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
