Originally posted by dbtoo
Does this muddy the waters?

http://download-west.oracle.com/docs...5a.htm#2063472

--------------------------------------------------------------------------------
Note:
On some operating systems, Oracle does not allocate space for the tempfile until the tempfile blocks are actually accessed. This delay in space allocation results in faster creation and resizing of tempfiles, but it requires that sufficient disk space is available when the tempfiles are later used. To avoid potential problems, before you create or resize a tempfile, ensure that the available disk space exceeds the size of the new tempfile or the increased size of a resized tempfile. The excess space should allow for anticipated increases in disk space use by unrelated operations as well. Then proceed with the creation or resizing operation.
dbtoo - Well, at least I know it's a feature, not a bug. Still curious why the systems behave differently though.

Oh well!

Thanks!
Jodie