Re: indexes?

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1998/03/22
Message-ID: <6f4o4h$cpq@bgtnsc03.worldnet.att.net>#1/1

I believe that you will receive the "ORA-00054: resource busy and acquire with NOWAIT specified" error message if you try to create an index on a table that another user is inserting/updating/deleting.

Hope this helps.

Michael Serbanescu

---

Peter Chan wrote:
>
> Could I create an index for a table that is in use? That is there is
> someone updating/inserting/deleting at the moment.
>
> Or do I have to stop all transactions on that table before creating the
> index?
>
> Thanks!
> - Peter
> --
Received on Sun Mar 22 1998 - 00:00:00 CST