Yes but I don't want to disturb users during this operation!!!
Peter Chan a écrit dans le message <3693A3AA.182ECA14_at_nortelnetworks.ca>...
>You could try one of the following solutions:
>
>1. Ask the user that has the table locked to do a rollback/commit, this
should
>unlock the table.
>
>2. Find the sid of the user who has the table locked and then kill the user
at
>the session level.
>
>I hope this helps.
>
>Serge Montet wrote:
>
>> Hello,
>>
>> I want to change the NEXT_EXTENT parameter for some indexes in my
database.
>> I always have a message saying it's impossible because the table is
locked
>> (and NOWAIT specified). How can I solve this problem ? I thought maybe
with
>> the LOCK TABLE command ?
>>
>> Thanks.
>
>--
>Peter Chan, Nortel Networks email: chanp_at_nortelnetworks.ca
>
>
Received on Wed Jan 06 1999 - 15:37:32 CST
