Rebuild table
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 21 Jun 2011 15:19:17 -0500
Message-ID: <BLU167-w1327EE0FB4BA6B2D4D298497510_at_phx.gbl>
Date: Tue, 21 Jun 2011 15:19:17 -0500
Message-ID: <BLU167-w1327EE0FB4BA6B2D4D298497510_at_phx.gbl>
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-lReceived on Tue Jun 21 2011 - 15:19:17 CDT