Re: sparse temp files

From: Roman Podshivalov <roman.podshivalov_at_gmail.com>
Date: Fri, 10 Oct 2008 13:16:51 -0400
Message-ID: <55f303590810101016l663793a9nefe627b3cbb2dd4@mail.gmail.com>


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_at_hotmail.com> 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>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 10 2008 - 12:16:51 CDT

Original text of this message