That is usually done by the application. You can attempt to
acquire a user lock in the share mode (ULS) before executing the
select and lock it in the exclusive mode (ULX) for admin purposes.
That is usually done through DBMS_LOCK package.
> -----Original Message-----
> From: John Dunn [mailto:john.dunn_at_sefas.co.uk]
> Sent: Friday, February 14, 2003 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Lock table and disallow select
>
>
> 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: Gogala, Mladen
INET: MGogala_at_oxhp.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 - 11:54:29 CST
