Re: exp/imp copy initial extent

susana73_at_hotmail.com (Susan Lam) 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

Download a proper editor like vim (www.vim.org) and change the initial extent using one command. Hopefully that's not asked too much. Other than that you are stuck.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 01 2002 - 03:02:51 CDT