Rebuild table

From: Joe Smith <joe_dba@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 21 Jun 2011 15:19:17 -0500

 
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.

Follow-Ups:
- Re: Rebuild table
  - From: Kish Patchava
- Re: Rebuild table
  - From: Greg Rahn
- RE: Rebuild table
  - From: Powell, Mark
- RE: Rebuild table
  - From: Sheehan, Jeremy
- RE: Rebuild table
  - From: Michael Rosenblum
- Re: Rebuild table
  - From: Hemant K Chitale

Other related posts:

» Rebuild table - Joe Smith
» Re: Rebuild table- Kish Patchava
» Re: Rebuild table- Greg Rahn
» RE: Rebuild table- Powell, Mark
» RE: Rebuild table- Sheehan, Jeremy
» Re: Rebuild table- Radoulov, Dimitre
» Re: Rebuild table- Radoulov, Dimitre
» RE: Rebuild table- Michael Rosenblum
» Re: Rebuild table- Hemant K Chitale
» Re: Rebuild table- Radoulov, Dimitre
» Re: Rebuild table- Radoulov, Dimitre
» Re: Rebuild table- Adric Norris
» Re: Rebuild table- Wayne Smith
» Re: Rebuild table- Radoulov, Dimitre
» Re: Rebuild table- Radoulov, Dimitre