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

Home -> Community -> Usenet -> c.d.o.misc -> Re: mysterious share table lock

Re: mysterious share table lock

From: Benjamin Toronto <btoronto_at_uswest.net>
Date: Wed, 12 Jan 2000 09:02:20 -0700
Message-ID: <387CA58C.61189D73@uswest.net> 





Amazing; it worked.  As you may have guessed, I am not an Oracle DBA,
just a lowly application developer, but I would like to know WHY inexing
the foreign key solves the problem.  Is it because the delete statement,
without an index, performs an implicit full table scan, thus requiring a
share table lock?  Is there any Oracle documentation on this?



Thank you very much for your help.



Ben Toronto


btoronto_at_bigfoot.com

Received on Wed Jan 12 2000 - 10:02:20 CST












Original text of this message













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