Re: how to reduce file size to minimum?

This can be done with the following statement

ALTER TABLESPACE tablespacename COALESCE;

This has the effect of compacting the data stored in the datafile to free up the partially used blocks into a large set of contiguous blocks. Then you can reduce the datafile (.dbf) size until it is close to 100% full WARNING!!! You should start the database in restricted mode to do this to ensure that there are no locks or procedures running.

Have fun

Patrick Greville-Morris
Consultant DBA

+49 (0)69 4980025 (Home)
+49 (0)1736647428 (Mobile)

"Norbert Lemke" <ofenroor_at_gmx.de> wrote in message news:9k5ubg$2rft1$1_at_ID-76747.news.dfncis.de...
> Hi,
>
> I need to reduce the free space in my database-files, therefore I want to
> minimize the filesize. To do this I have to reorganize the segments that
 all
> segments are located at the beginning of the datafiles.
>
> How can I do this (except export all the database)?
>
> Regards,
> Norbert
>
>
Received on Tue Jul 31 2001 - 06:44:17 CDT