Re: Best bet for table defragmentation

It is assumed... You can verily this.How much space should this table consume?

On 17/08/07, Khan, Muhammad S <Muhammad.Khan@xxxxxx> wrote:
> 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,
>
>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Other related posts: