Re: Running time of index rebuild
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 5 Jun 2013 15:27:35 -0500
Message-ID: <CAGRGHjw38J27_usvCr+XBGXsQAokf+ZnzMgevyobtwry-qSJxw_at_mail.gmail.com>
Ingrid,
Take a look at ALTER INDEX REBUILD TABLESPACE ONLINE. In my experience that will move the index to a new tablespace that will hopefully save you the space you require. I believe the speed of this operation will be much faster than building the index from scratch.
Date: Wed, 5 Jun 2013 15:27:35 -0500
Message-ID: <CAGRGHjw38J27_usvCr+XBGXsQAokf+ZnzMgevyobtwry-qSJxw_at_mail.gmail.com>
Ingrid,
Take a look at ALTER INDEX REBUILD TABLESPACE ONLINE. In my experience that will move the index to a new tablespace that will hopefully save you the space you require. I believe the speed of this operation will be much faster than building the index from scratch.
Dennis Williams
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 05 2013 - 22:27:35 CEST