Re: sparse temp files

  • From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
  • To: joe_dba@xxxxxxxxxxx
  • Date: Fri, 10 Oct 2008 13:16:51 -0400

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>
>

Other related posts: