Arda wrote:

>
> Thank you Dmitry, but when I set the transaction option to WAIT and
> try, it never starts creating the index and waits for ever. There are
> about 150 users on the site. Can this be because one of the clients
> crashed when it was in the middle of a transaction?

I don't think so. Most probably users just don't have any pause in their
table modifications. If so, a database shutdown would be your only choice.


Dmitry