Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Lock an Index
Ted Persky wrote:
>
> Hi gurus:
>
> Can anyone shed some light on this problem?
>
> This morning an index was getting close to its MAXEXTENTS value. When I
> tried to do an "alter index" to increase MAXEXTENTS by ten, it returned
> an ORA-00054 error, that the index was busy and that I had issued the
> command with NOWAIT. I couldn't find a "WAIT" option to the "alter
> index" command.
>
> Since I didn't see a "lock index" command, I manually locked its
> associated table in exclusive mode. Still, I got the ORA-00054 error.
> What process could be accessing the index if I've got the table in an
> exclusive lock? What is the best way to lock the index, so that I can
> alter the MAXEXTENTS?
>
> Sincerely,
>
> Ted Persky
> TPersky_at_sempra.com
The one sure way of avoiding this problem is to mount the database in exlusive mode and then modify the storage parameters from within svrmgrl. Received on Thu Feb 03 2000 - 07:15:27 CST