do it in parallel(paralellel hint) with nologging and then use dbms_job and create all the indexes at the same. you can run them in the background

you will get some I/O contention doing this, but it should still be faster.
>
> From: Venugopal.[Email Address Removed] Date: 2003/05/30 Fri AM 07:57:04 EDT
> To: "LazyDBA.com Discussion" <[Email Address Removed] 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] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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