Re: Reorganisation of a large database table

One other point - what platform are you on? If you've only got 2GB hard drives you might want to combine them with a Logical Volume Manager. You might also want to consider striping the drives at the same time for better performance (fine-grained and automatic with an LVM or hardware controller, not the pain-in-the-butt Oracle striping) for such a large table.

MotoX.

Pavel Polcar wrote in message <01bda4c6$5be24fc0$47c3657e_at_polcar_nt4006>...
>Hi Sigrid,
>you can do the export with COMPRESS=N, then drop and recreate the table
>with the storage parameters that you wish (e.g. initial 100 MB next 100M)
>and
>then import the data with IGNORE=Y.
>
>Regards,
>--
>Pavel Polcar
>
>Sigrid Staudte <sstaudte_at_sachsenlb.de> wrote in article
><3598109D.11A59A42_at_sachsenlb.de>...
>> Hallo,
>>
>> I have a 8 GByte database table containing word documents as
>> ole-objects. In this table the largest documents was replaced with
>> smaller documents. Now I have to reorganize this table. The best way is
>> to start the export utility of oracle with the compress extents option
>> at first and secondly start the import utility. But when I use the
>> export utility with compress extents, oracle want to create an initial
>> extent bigger than 2 GBytes - but I only have some 2-GByte hdd´s at the
>> server. Is there any way to reorganize this table?
>> Is it possible to edit the export file to reduce the size of the initial
>> extent of the database table?
>>
>> Regards,
>>
>> Sigrid
>>
Received on Thu Jul 02 1998 - 00:00:00 CDT