Something like: dd if=/dev/zero of=<temp file> bs=8192 count=<number> create temporary tablespace temp tempfile <temp file> reuse. --romas On Fri, Oct 10, 2008 at 12:41 PM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > How do you create temporary files as non-sparse files in oracle? > > I thought there was a note on metalink about this, but I can't find it > now. > > > thanks. > > > > > ------------------------------ > Get more out of the Web. Learn 10 hidden secrets of Windows Live. Learn > Now<http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_getmore_092008> >