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

From: Yvan GALAS <yvan.galas_at_fr.adp.com>
Date: Tue, 08 Apr 2003 16:23:51 +0200
Message-ID: <b6um58$oji$1@pegase.atos-infogerance.fr>

Yes sorry to be more precise :

I assume that you are in 9i cause SEGMENT SPACE MANAGEMENT doesn't exist in 8i

If you specify : EXTENT MANAGEMENT LOCAL AUTOALLOCATE (Be care of blob objects..)

first you cannot specify a DEFAULT STORAGE CLAUSE
second oracle activate SEGMENT SPACE MANAGEMENT AUTO with a inital extent of 1M (If your block size is 16K or more)

If you specify LOCAL and want to allocate your DEFAULT STORAGE CLAUSE as usual you must specify SEGMENT SPACE MANAGEMENT MANUAL

All of this information is in ORACLE DATABASE CONCEPTS.

Howard J. Rogers wrote:
> 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 - 09:23:51 CDT