Re: Rebuild table

From: Kish Patchava <kish.patchava_at_gmail.com>
Date: Tue, 21 Jun 2011 16:28:40 -0400
Message-ID: <BANLkTinJ2=FBDeBge86Q3hWqaXH3Ba2HBA_at_mail.gmail.com>

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 <joe_dba_at_hotmail.com> 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.
>
>

--
http://www.freelists.org/webpage/oracle-l

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