Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9i Referential Integrity Locking

9i Referential Integrity Locking

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 03 Apr 2002 21:03:54 GMT
Message-ID: <_6Kq8.25970$VQ2.8478861@twister.socal.rr.com> 





It appears that Oracle 9i no longer acquires a share level table lock on
a child table when rows are deleted from the parent table and no
supporting index exists on the child table.  This was the locking
strategy used in earlier versions.  Am I wrong?  Is there a document
somewhere that describes the new enforcement strategy they are using? 
Are there different side effects caused by it?




thanks,


Richard Kuhler
Received on Wed Apr 03 2002 - 15:03:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US