Re: Table locking

A copy of this was sent to Bret <barkndog_at_mindspring.com> (if that email address didn't require changing) On Thu, 06 Jan 2000 15:56:40 -0500, you 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

The QUERIES would have to use "select ... for update" if you want them to block, else they do not block. It just doesn't work that way (blocking queries)..

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jan 07 2000 - 07:13:46 CST