Re: How to "Defragment" Tablespaces ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 28 Mar 2001 21:03:47 +0200
Message-ID: <tc4d8oh64knpcb@beta-news.demon.nl>

"Sylvain Brun" <sbrun_at_infologic.fr> wrote in message news:99tba2$d3r$1_at_s1.read.news.oleane.net...
> 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
> =================================
>
>
>

There is no sql syntax for this, and definitely not in 7.3.4

You need to go the exp/imp route (so exp, drop the objects, and import) or buy Platinum TSReorg.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Mar 28 2001 - 13:03:47 CST