RE: Rebuild table

  • From: "Powell, Mark" <mark.powell2@xxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Jun 2011 20:29:08 +0000

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.

Other related posts: