Question on re-organising Tables

From: John Wood <jwood_at_hotmail.com>
Date: Thu, 07 Oct 2004 03:45:32 GMT
Message-ID: <wZ29d.33714$223.19097@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. Received on Wed Oct 06 2004 - 22:45:32 CDT