Extra 2c. I would suggest as a possible solution already mentioned ALTER TABLE ... MOVE, but fired twice: - first, move everything to completely different tablespace - second, move it back where the data belongs - rebuild indexes To be fair, I don't exactly remember the real case, but sometimes ago (Oracle 10g R2 on Win32) this double-jump solved my space allocation problem, while single operation was not not giving me what I wanted. Regards, Michael Rosenblum ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith [joe_dba@xxxxxxxxxxx] 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.