Re: Table locking

Bret wrote:

> I am using Oracle 8.0.5.
> I need to lock an individual table, not only to updates but to queries.
> I cannot find a way to make the server queue queries to a table while I
> am updating it (before I commit the changes). Currently the database
> will queue updates to a table, but will allow queries.
>
> I do not need this behavior for every table, just a few particular
> ones. Could anyone give me any information or hints as to how to
> accomplish this? The documentation is unclear, and I couldn't find this
> question at orafaq.com. Thanks for any help.
>
> Bret

I don't mean to be picky but why do you need to do this. Oracle provides a read consistent view for all queries while your update is running anyway. As long as the changes are broken into logical transactions correctly there shouldn't really be a problem.

Ken. Received on Fri Jan 07 2000 - 09:39:53 CST