Re: fragmentation of a tablespace

ythorne_at_acs.neu.edu wrote:
>
> Is it possible to defrag a tablespace without exporting/importing the
> entire database?

  You can try to use the following command:   ALTER TABLESPACE tablespace COALESCE;

  Alternatively, there are some third party products that support defragmentation.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841