Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to "Defragment" Tablespaces ?

Re: How to "Defragment" Tablespaces ?

From: Carl <c_joh_at_hotmail.com>
Date: Wed, 28 Mar 2001 20:21:20 GMT
Message-ID: <svg4ct4l976iakgnkt90m307inb117518c@4ax.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US