Oracle-L: Re:Lock table and disallow select

From: <dgoulet_at_vicr.com>
Date: Fri, 14 Feb 2003 10:24:17 -0800
Message-ID: <F001.0054DFD1.20030214102417@fatcity.com>

John,

No.

Dick Goulet

____________________Reply Separator____________________
Author: John Dunn <john.dunn_at_sefas.co.uk>
Date:       2/14/2003 7:04 AM

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?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: dgoulet_at_vicr.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).

Received on Fri Feb 14 2003 - 12:24:17 CST