Re: Export / Import from 8i to 9i and locally managed tablespace

From: Howard J. Rogers <howardjr20002_at_yahoo.com.au>
Date: Tue, 8 Apr 2003 21:57:11 +1000
Message-ID: <%Dyka.9742$1s1.163351@newsfeeds.bigpond.com>

"Yvan GALAS" <yvan.galas_at_fr.adp.com> wrote in message news:b6u7a4$iup$2_at_pegase.atos-infogerance.fr...
> Hi,
>
> Yes by default segment space auto is 1M extent, you can specify 'segment
> space management manual' when you create your tablespace...
>

Eh?

By default, segment space auto (ie, 'segment space management auto' as part of the create tablespace statement) implies absolutely nothing about extent sizes, merely that space management should be performed using bitmaps rather than freelists.

Where do you get the idea that ASSM has anything to do with extent sizes??

Regards
HJR Received on Tue Apr 08 2003 - 06:57:11 CDT