Mark,
I had OTS recommend setting this back on version 6.0.36 due to a bug. But
since I've removed it.
Dick Goulet
____________________Reply Separator____________________
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date: 4/12/2001 11:55 PM
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
> <[EMAIL PROTECTED]>
>
> > 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
