| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lock table and disallow select
Aren't we looking for trouble with this scenario? What if you hold lock for
more than few seconds/minutes/hours? I'd ask following questions ...
AFAIK one way to do this is to break the synonym pointing to the database, but any other code owned by the same schema will continue to look at a read consistent image of the table. Also by breaking the synonym, you risk having invalid code in the database and it is a cascading effect...
Seriously, I'd find why your user would like to do this. Raj
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Friday, February 14, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
Query from user. can the following be done in PL/SQL?
> I need to be able to lock a table in such a way that not only can no other
> session alter any records in the table, but they cannot read the table at
> all (i.e. do SELECTs on it) until I'm done with it.
>
> Any SELECT statements would pause until I release the lock.
>
> Is such a thing possible?
--Received on Fri Feb 14 2003 - 09:29:32 CST-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
- text/plain attachment: ESPN_Disclaimer.txt
 |
 |