Re: How to "Defragment" Tablespaces ?

Hello!

You need to export the tablespace (with compress = Y), drop it recreate the tablespace and import it.

-Carl

On Wed, 28 Mar 2001 20:41:06 +0200, "Sylvain Brun" <sbrun_at_infologic.fr> wrote:

> Hello,
>
>Got Oracle Server 7.3.4, and would like to defragment some
>of my tablespaces.
>
>I tried to do this with "Tablespace Manager", but anything I
>can do (connected as System, having all rights set on, with admin
>option...),
>the "defragment" button is always disabled !
>
>Please, explain me how to do, or tell me what is the SQL syntax for this.
>
>Thanks,
>
>Sylvain.
Received on Wed Mar 28 2001 - 14:21:20 CST