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: 10677
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: Query on namespace and dbms_session.set_context
Next Topic: Table as variable and looping
Goto Forum:

Current Time: Sat Aug 19 13:53:56 CDT 2017

Total time taken to generate the page: 0.00760 seconds