Re: Temp Tablespace very large oracle 9ir2

On Tue, 29 Nov 2005 15:53:03 -0800, aj70000 wrote:

> Thanks for the reply. So is it the case that if you have maxsize
> defined on the datafile,it will try to reuse the space within the file
> after cleaning the used blocks? or it will complain about the file not
> being able to grow beyond the maxextents?
>

If the temp segments are unused (even though they are allocated), it will reuse them first and then complain if it still runs out of space.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***