RE: lock modes

Nope:)

I can't for the life of me think why somebody would set this to none, as it could seriously damage your data integrity right? Sorry, I forgot to mention all of this in my original post.. Thanks Jared.

Mark

-----Original Message-----
Sent: Friday, April 13, 2001 02:30
To: Multiple recipients of list ORACLE-L

Mark,

The parameter ROW_LOCKING defaults to 'ALWAYS', and is considered the normal behavior of Oracle.

I've never heard of anyone explicitly setting this parameter. Do you know of some situation where that would be needed?

Jared

On Thursday 12 April 2001 12:47, Mark Leith wrote:
> In answer to the original question:
>
> Exclusive: means that the table in question is locked by a user
> exclusively. This is usually used as shown below by Ep, to stop other
users
> *modifying* the data within the table (they can still select).
>
> Row Exclusive: You can specify an init parameter ROW_LOCKING, this will
> force a lock to be applied each time a row is updated.
>
> None: Means what it says on the tin:) There are no locks applied.
>
> HTH
>
> Mark
>
> -----Original Message-----
> Pierce
> Sent: Thursday, April 12, 2001 07:06
> To: Multiple recipients of list ORACLE-L
>
>
> Partial answer only:
>
> See below for a code example (something I use to irritate
> users if run during normal data enty times!).
>
> It shows how how to lock a table for "mass update" while
> running in SQL*plus (amazing enough, it was probably
> originally found in an Oracle manual).
>
> Regards,
> Eric
>
>
> ---begin---
>
> whenever sqlerror exit sql.code ;
> lock table STUDENT_MASTER in exclusive mode nowait ;
> whenever sqlerror continue ;
>
> ---end---
>
>
> On 12 Apr 2001, at 9:26, Bunyamin K.Karadeniz wrote:
>
> Date sent: Thu, 12 Apr 2001 09:26:40 -0800
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
>
> > Can anyone explain the lock modes written below.What do they mean . And
>
> how will I open the lock?
>
> > Regards
> >
> > Exclusive
> > Row Excl.
> > None
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric D. Pierce
> INET: PierceED_at_csus.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
--
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).