Re: Reorganisation of a large database table

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 1998/07/01
Message-ID: <01bda4c6$5be24fc0$47c3657e@polcar_nt4006>#1/1

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 Wed Jul 01 1998 - 00:00:00 CDT