RE: Rebuild table
From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com>
Date: Tue, 21 Jun 2011 16:34:26 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF1F5303510B_at_GOXEXVS03.fplu.fpl.com>
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.
Date: Tue, 21 Jun 2011 16:34:26 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF1F5303510B_at_GOXEXVS03.fplu.fpl.com>
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.
Thanks,
Jeremy
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith
Sent: Tuesday, June 21, 2011 4:19 PM
To: oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 21 2011 - 15:34:26 CDT