What are the reasons for the rebuild. Is it due to:
a) Block Corruption
b) Fragmentation
c) Reduce the size of index tablespace
Sri
-----Original Message-----
From: Venugopal.[Email Address Removed] Friday, May 30, 2003 6:57 AM
To: LazyDBA.com Discussion
Subject: Rebuilding of a big table
Hi! Gurus,
We are having a big table of around 50 GB. The indexes of the table is
around 45 GB. I would like to know the easiest way to rebuild the indexes
and the table.
Venugopal
*************************************************************************************************
DISCLAIMER: Information contained and transmitted by
this E-MAIL including any attachment is proprietary to UTI Bank Ltd and is
intended solely for the addressee/s, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
Access to this e-mail and/or to the attachment by anyone else is
unauthorized. If this is a forwarded message, the content and the views
expressed in this E-MAIL may not reflect those of the Bank. If you are not
the intended recipient, an agent of the intended recipient or a person
responsible for delivering the information to the named recipient, you are
notified that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is strictly
prohibited. If you are not the intended recipient of this mail kindly
delete from your system and inform the sender. There is no guarantee that
the integrity of this communication has been maintained and nor is this
communication free of viruses, interceptions or interference.
*************************************************************************************************
--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page