Re: exp/imp and extents

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 22 Mar 2004 22:16:56 +0100
Message-ID: <frlu50pk1hprn62vlcso0vptap16hd71na@4ax.com>

On 22 Mar 2004 11:45:13 -0800, richchri_at_erols.com (richie) wrote:

>I would of expected the new object to take up 1M since it had no data
>in the table. However, it allocated just as much space from the
>tablespace as if it had all the data in the table.
>
>Is this right? Should this be right? If so, why why why?

You exported the table with compress=Y (which is the default) The effect of this is you will get an initial extent which equates to the total allocation for the object.
You should always export with compress=N

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Mar 22 2004 - 15:16:56 CST