Re: reorg of Oracle10g tablespace in offline mode

On Sun, 12 Aug 2007 08:21:35 +0200, "astalavista" <nobody_at_nowhere.com> wrote:

>What about ?
>alter table xxx enable row movement
>alter table xxx shrink space
>

The central question whether any of those actions will *SOLVE* anything, or will be recurring and just waste the OP's time, providing a false sense of confidence.
As stated a locally managed tablespace can't fragment, EVER.

-- 
Sybrand Bakker
Senior Oracle DBA