Re: reclaiming wasted space in Oracle

On Wed, 14 May 2014 14:46:20 -0700, Mark D Powell wrote:

> If you issue "alter table owner.t_1 move;" then Oracle by default
> performs the move the table's assigned tablespace. The same is true on
> an index rebuild.
>
> HTH -- Mark D Powell --

Also, there is a command "ALTER TABLE SHRINK SPACE" which can shrink unused space in the table. That command should not be confused with the TRUNCATE TABLE command, which also shrinks space in the table. There are subtle but significant differences between the two commands.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com