Home » SQL & PL/SQL » SQL & PL/SQL » ORA :01652
icon14.gif  ORA :01652 [message #217788] Mon, 05 February 2007 09:14 Go to next message
Messages: 2
Registered: February 2007
Location: INDIA
Junior Member
we are facing these error.
we have modified the temp tablespace to 128MB.
but still we are facing these error.
so please suggest a better solution to resolve these..

thanks and Regards.

[Updated on: Mon, 05 February 2007 22:14]

Report message to a moderator

Re: ORA :01652 [message #217789 is a reply to message #217788] Mon, 05 February 2007 09:21 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Always Post the complete error message and when it is occuring.
>>we have modified the temp tablespace to 256.
256 what? Mb? Gb? or Kb?
You may need to increase it to more.
Some operations will require more tempspace to do the sort.
May be your sql code is too bad making unnecessary sort.
Previous Topic: How to create a Column that will "carry over" values
Next Topic: How do I trace another session into a table?
Goto Forum:

Current Time: Fri Oct 28 07:29:22 CDT 2016

Total time taken to generate the page: 0.04757 seconds