Re: Question on re-organising Tables

"John Wood" <jwood_at_hotmail.com> wrote in message news:<wZ29d.33714$223.19097_at_edtnps89>...
> We have Oracle 9i on Win2K environment. We have created some very big
> tables in a user tablespace. As now we found the tables are not used much.
> It contains much less data. I would like to rebuild the table using
> Exp/Imp. But when I export the tables, the export file would contain a
> statement to create the table with big initial extent.
>
> If I export the tables with COMPRESS=N, then I think I can prevent the
> tables from creating with large initial extent. I have enabled the Local
> Managed Tablespace. The question is: Is it okay to do so as the Local
> Managed Tablespace would allocate 64K at a time ? The tables would probably
> involve about 200M to 500M of data. Will there be any performance issue ?
>
> Thanks.
>
> JW.

Why not create a new LMT tablespace with uniform size of 32 Mb and issue the statement "alter table xxxxx move tablespace new_LMT storage(initial 32M);"

That way you don't have to exp/imp the table

Best regards

Hans Received on Thu Oct 07 2004 - 08:37:01 CDT