Quote Originally Posted by cis_groupie
Bear in mind how the TEMP tablespace works - if you let it grow then it will, if you don't then it will reuse no longer needed space. With autoextend on it will continue to allocate space, but if you turn autoextend off then when it reaches full it will start re-using previously allocated space (if that makes sense!).
Hi,

thanks, is it written somewhere in the documentation? I'll take a look, it's seems strange to me the space is no longer reused once released when working in autoextend mode, it would be rather silly. I am just used to traditional Oracle7/8 temp tablespaces. But this could explain why I am running into this. Also the database is closed each night during a backup. Everything works fine for a few days, the temp file does not even grow beyond 1Gb and then suddenly one day it bursts into the OS limit which is 30GB. I had a feeling this is still related to the 4GB Oracle bug.

I will try the option without the autoextend off.

Many thanks,
Richard.