Table locking

From: Bret <barkndog_at_mindspring.com>
Date: Thu, 06 Jan 2000 15:56:40 -0500
Message-ID: <38750188.D79D5820@tstnet.com>

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 Received on Thu Jan 06 2000 - 14:56:40 CST