Home » RDBMS Server » Server Administration » running out of TEMP space (11.2.0.4)
running out of TEMP space [message #635531] Tue, 31 March 2015 11:06 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,

I am getting the error ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
while running a dml statement. I increased the TEMP size by 60g and get rid of the error.
But now when developers try to run the batch, they are getting the same error.
I have following question:-

Do I need to keep adding more temp space or it could be related to some different underlying issue?

Thanks,

Varun
 
Read Message
Read Message
Previous Topic: How to upgrade time zone binaries
Next Topic: Index Organized Table
Goto Forum:
  


Current Time: Fri Apr 26 23:11:24 CDT 2024