Re: Exclusive lock

From: Graham Miller <lgmiller_at_elmrd.u-net.com>
Date: Sat, 18 Apr 1998 19:13:31 GMT
Message-ID: <353df8e3.13440312@news.u-net.com>

Yoav <yoav_bz_at_netvision.net.il> wrote (in <3538DCE1.CDDE0A9B_at_netvision.net.il>)...

| Hi,
| Does anyone knows how can I issue a "real" exclusive lock in Oracle ?
| When saying "real", I mean that no one else can even SELECT the
| row/table.
|
| (I thought to use latch or try and update v$ tables).
|
| thanks,
|
| Joe
| ---------------------------------
| yoav_bz_at_netvision.net.il

Hello,
It is impossible to stop another query reading rows locked in your transaction when the other transactions can 'see' the base table. This is always a 'good' thing. imo

However, What problem are you trying to solve. An overview of what you want to do is required.
Because Oracle cannot stop readers doesn't mean that it cannot solve the problem you have! Normally, a different approach to the problem is required, that is all. Oracle is perfectly capable of denying access to any query which shouldn't 'see' certain rows, in almost any and all circumstances that you wish to specify. For example, a view can be used to control which users see which rows.

graham Received on Sat Apr 18 1998 - 14:13:31 CDT