Resouce busy error and indexes

From: <robertchung0909_at_my-deja.com>
Date: Mon, 21 Feb 2000 16:35:00 GMT
Message-ID: <88rpfk$9mp$1@nnrp1.deja.com>

I am trying to create small indexes on tables when users are accessing them, but getting following error:

ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

I get this error even when I lock the table in exclusive mode. Is there something that I can do? I do not want to kick users out or go through database maintenance outage just for a couple of small indexes. Thank you in advance.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 10:35:00 CST