Re: Fasten huge index rebuild - How To ?

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 19 May 2005 11:59:33 -0400
Message-ID: <428CB7E5.4020806@allegientsystems.com>

Prem Khanna J wrote:

>Hi All ,
>
>One of my collegue has got a problem on index rebuilds.
>
>
>people/application do if they have a huge index and it gets corrupt
>and needs to be rebuilt and the rebuild time normally takes days?
>
>

If it is a local index, it can be rebuilt, partition by partition, one partition every day.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 19 2005 - 12:06:26 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Fellow Oakie wins an award!!!"
Previous message: Paul Drake: "Re: Limit sort space used by Discoverer"
In reply to: Prem Khanna J: "Fasten huge index rebuild - How To ?"
Next in thread: Connor McDonald: "Re: Fasten huge index rebuild - How To ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US