RE: Rebuild table
From: Powell, Mark <mark.powell2_at_hp.com>
Date: Tue, 21 Jun 2011 20:29:08 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B17241593746015792E_at_GVW1337EXC.americas.hpqcorp.net>
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_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
Date: Tue, 21 Jun 2011 20:29:08 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B17241593746015792E_at_GVW1337EXC.americas.hpqcorp.net>
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_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:29:08 CDT