Re: reclaiming wasted space in Oracle

From: Mladen Gogala <>
Date: Wed, 14 May 2014 23:52:46 +0000 (UTC)
Message-ID: <>

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
Received on Thu May 15 2014 - 01:52:46 CEST

Original text of this message