Re: Locks

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 - 11:55:54 CST