RE: EXPORT Qs. - INITIAL EXTENT Sizing

Hi,

Supose you have initial = 1M and next = 1M and your table has initialy 4 extents.
With compress=yes you will have an initial of 5M. Dependig on pctfree, pctused, the data distribution, and how much is filled the last extents you´ll have more or less free space for new rows. Normally you have ADDITIONAL EMPTY space.

HTH         Joselu

> -----Mensaje original-----
> De: VIVEK_SHARMA [SMTP:vivek_sharma_at_inf.com]
> Enviado el: miércoles 24 de mayo de 2000 10:54
> Para: Multiple recipients of list ORACLE-L
> Asunto: EXPORT Qs. - INITIAL EXTENT Sizing
>
>
> 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
>
>
> --
> Author: VIVEK_SHARMA
> INET: vivek_sharma_at_inf.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 24 2000 - 05:36:07 CDT