Re: About defragmentation

From: Meinolf Klement <Meinolf.Klement_at_t-online.de>
Date: Mon, 14 Dec 1998 16:45:31 GMT
Message-ID: <36710691.1518731@news.btx.dtag.de>

On Sat, 28 Nov 1998 12:42:10 +0200, Anastasios Tsibelekidis <atsi_at_intranet.gr> wrote:

>Hello,
>
>How can i perform ONLINE defragmentation.
>(I have 8.0.3 on Sun Solaris.)
>
>Regards, Anastassios Tsivelekidis,
>INTRACOM S.A., Greece
>
>
>

The best way (may be only?) is to export the data, drop the tablespace, re-create it and import the data. Make sure to test it in a seperate environment (especially for very large exports (>2GB). Received on Mon Dec 14 1998 - 10:45:31 CST