On Wed, Jun 1, 2011 at 2:41 AM, Vander Clock Stephane
<svanderclock@...> wrote:

>
> is it possible inside a stored procedure to dedactivate some index, do
> the job, and reactivate the index at the end ?

Yes, with execute statement. But the probability is that the deactivation
will fail because some other transaction has a reference to the index.

It would be more reliable to deactivate the index from the user process then
run the procedure, then reactivate from the client again.

Good luck,

Ann