Re: Rebuild table

From: Kish Patchava <>
Date: Tue, 21 Jun 2011 16:28:40 -0400
Message-ID: <>

You can adjust High Water Mark of the table if the database is 10g or higher.

alter table tab_name enable row movement; alter table tabl_name shrink space cascade;

On Tue, Jun 21, 2011 at 4:19 PM, Joe Smith <> wrote:

> I have a table that had 16 million records in it. I deleted rows out of it
> until I had only 6k rows. But I still have 57k blocks (8k size).
> What is the best way to rebuild the table? The table is varchar2 and
> number datatypes.

Received on Tue Jun 21 2011 - 15:28:40 CDT

Original text of this message