Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Best bet for table defragmentation

Best bet for table defragmentation

From: Khan, Muhammad S <Muhammad.Khan_at_ca.com>
Date: Fri, 17 Aug 2007 11:56:13 -0400
Message-ID: <06FBECFB25A476489623850EE472C29F03EB4CEF@USILMS12.ca.com>


Its Oracle 9.2.0.7 on Solaris, we have a transaction table with approximately 68 million rows. It is consisting of about 100GB space in the tablespace and it is assumed that it is highly fragmented. We definitely need some space at that tablespace and for that we were discussing the methods for defragmenting it and get some space back. One suggested method was export/import but that would take atleast 6 hours while another one was moving the table to another tablespace and rebuild the indexes which would not require any downtime.  

Does any guru have any other suggestion regarding that? Or your input about the above methods as per knowledge and experience???  

Thanks,  

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 17 2007 - 10:56:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US