Re: How to "Defragment" Tablespaces ?

Try
alter tablespace tbs reorg;
(I'm not sure about the syntax)

Sylvain Brun 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.
>
> --
> =================================
> Sylvain Brun -- Société INFOLOGIC
> - Services et conseils en Informatique -
> Tél. 04 75 82 16 40 - Fax. 04 75 82 16 38
> =================================
Received on Sat Mar 31 2001 - 09:23:39 CST