maxextents [message #371864] |
Fri, 15 December 2000 03:32 |
Uday
Messages: 21 Registered: December 2000
|
Junior Member |
|
|
Hi
pls tell me what the solution for the prob.
like ORA-01652,unable to extend temp segment by 61446 in tablespace TEMP
thanks
|
|
|
Re: maxextents [message #371866 is a reply to message #371864] |
Fri, 15 December 2000 03:39 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
This problem was caused by the system attempting to allocate more space in the TEMP tablespace, and finding the tablespace was now full.
The TEMP tablespace is used for sorting and grouping operations in queries, amongst other things.
Solutions include : Get your DBA to extend the size of the TEMP tablespace, Rewrite your query to run as several seperate queries, or rewrite your query to use less gropu/sort operations.
|
|
|
Re: maxextents [message #372237 is a reply to message #371864] |
Sun, 21 January 2001 14:29 |
aadit
Messages: 2 Registered: January 2001
|
Junior Member |
|
|
I have 44 GIG of Temporary tablespace set in my Database. But received the same error message. I can not extend the space any more. I assume 44 GIG itself is too large. How did you solve your problem. Please help me.
|
|
|