It is assumed... You can verily this.How much space should this table consume?
On 17/08/07, Khan, Muhammad S <Muhammad.Khan_at_ca.com> 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
Received on Fri Aug 17 2007 - 12:27:48 CDT
