Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extent management local problem

Re: Extent management local problem

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 2 May 2003 12:02:32 +0100
Message-ID: <3eb2504d$0$29715$ed9e5944@reading.news.pipex.net>


"Peter van Rijn" <p.vanrijnRM_at_THISzhew.nl> wrote in message news:vb4h08qrm0qn0a_at_corp.supernews.com... <snip clear explanation>
> Third:
> ====
> If you use this alternate form you will HAVE to use the TEMPFILE clause. I
> don't know how the tempfiles are implemented on Wondows, but on Unix they
> are created as so-called sparse files. That's why this sort of tablespace
> creation is so incredibly fast.

They are sparse on 2000/XP, though not IIRC on NT4.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri May 02 2003 - 06:02:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US