yes, like a run "execute block" as script!

On Wed, Jun 1, 2011 at 11:44 AM, Ann Harrison <aharrison@...>wrote:

>
>
> 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
>
>
>



--
Ricardo...


[Non-text portions of this message have been removed]