Re: compress a tablespace

From: A.Liggins <A.Liggins_at_hotmail.com>
Date: Sat, 8 Sep 2001 12:37:10 +0100
Message-ID: <9nd00p$fb5$1@neptunium.btinternet.com>

What version of Oracle?

Anyway you can rebuild indexes with the ALTER INDEX command (build to another tablespace and then back if space is short). Do a tablespace coalesce inbetween.

"@nnib" <annibale_at_ifrance.com> wrote in message news:9msuqb$k38$1_at_capella.worldonline.fr...
>
> hi,
>
> i've got a tablespace with a big fragmentation.
> does the "export - drop objects - import" is the unique solution ?
>
> thanx
> @nnib
>
>
Received on Sat Sep 08 2001 - 06:37:10 CDT