RE: Rebuild table

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.

Other related posts: