RE: Rebuild table

From: Sheehan, Jeremy <>
Date: Tue, 21 Jun 2011 16:34:26 -0400
Message-ID: <>

Lots of good information pouring in. just make sure to check for invalid objects post move/rebuild. If you do CTAS, make sure you get the permissions correct on the new table, too.



From: [] On Behalf Of Joe Smith Sent: Tuesday, June 21, 2011 4:19 PM
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.

Received on Tue Jun 21 2011 - 15:34:26 CDT

Original text of this message