Re: exp/imp copy initial extent

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 1 Oct 2002 01:46:08 -0400
Message-ID: <upidl2oqfckk7c@corp.supernews.com>

Susan,

"deallocate unused" is your friend (alter table ... deallocate unused keep ..) The link below might wrap:
http://groups.google.com/groups?q=deallocate+unused+storage&hl=en&lr=&ie=UTF-8&selm=323A6362.A03%40jlcomp.demon.co.uk&rnum=9

Anurag

"Susan Lam" <susana73_at_hotmail.com> wrote in message news:7186ed56.0209301718.4fd7ca41_at_posting.google.com...
> I got a dmp file from a business partner and I need to import it to
> our database. The dmp file is only 1M but after I import it occupies
> 1GB! The reason is they set the initial extent of all tables, index
> to 20M even they don't have much data at all. I tried make the
> tablespace locally manage with "autoallocate" or "uniform size" before
> importing but it does not help.
>
> Is there any way to fix the initial extent size? The only way I know
> is edit/modify all the tables/indexes script to change the extent size
> before importing but I do not want to do it.
>
> Thanks,
> Susan
Received on Tue Oct 01 2002 - 00:46:08 CDT