Re: How to "Defragment" Tablespaces ?

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
> =================================

export / import

and before you do this, work on a fixed extent size policy per tablespace, and you wont have to do the exercise again...

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"