Re: EXPORT Qs. - INITIAL EXTENT Sizing

From: kgopal <kgopal_at_mantraonline.com>
Date: Wed, 24 May 2000 14:45:47
Message-Id: <10507.106493@fatcity.com>

Hi !

The single extent will be the sum of all extents. It doesn't care about the space usage within that extent.

K Gopalakrishnan

At 01:02 PM 5/24/00 +0530, VIVEK_SHARMA wrote:
>
>exported 1 Table with COMPRESS=Y
>Dropped the Table
>Imported it back in
>Qs . Will the Single Extent Allocated be Completely Filled with Data or will
>it have any ADDITIONAL EMPTY Space too ?
>i.e. Will the INITIAL EXTENT Sizing grow proportionately only to the Amount
>of Data in the Table ?
>
>ASSUMING - Sufficient FREE Space Exists in the Tablespace for 1 Contiguous
>Extent
>
>
>
>--------
>If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
>to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
>to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Wed May 24 2000 - 14:45:47 CDT