You do not mention your Oracle version but alter table x move has been around a while now so I would try this command followed by an alter index idx rebuild for each index defined on the table. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith Sent: Tuesday, June 21, 2011 4:19 PM To: oracle-l@xxxxxxxxxxxxx Subject: Rebuild table 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.