From: Mark D Powell Subject: Re: switching locking off? Date: 2000/07/07 Message-ID: <132d6368.76d6a8b4@usw-ex0103-024.remarq.com>#1/1 References: <8k4qei$k3t$1@soap.pipex.net> Bytes: 603 X-Originating-Host: 199.228.142.8 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon4 963000841 10.0.2.24 (Fri, 07 Jul 2000 13:14:01 PDT) Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here NNTP-Posting-Date: Fri, 07 Jul 2000 13:14:01 PDT Newsgroups: comp.databases.oracle.server X-Wren-Trace: eEdiSktSFV8UClJdSUlWQUJRW05iRgNCDEhHSQ4CB14GE1UeB1YGGwUe You can not turn off Oracle row level locking, but you can do demonstrate what you want using the dbms_lock package. Create a document as a set of rows. You can have two sessions, same or different users, update different rows creating an inconsistent document. You can then demo the protection afforded by a user lock created and obtained by using dbms_lock. DBMS_LOCK is documented in the Application Developers Guide. ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com