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 -> Locking issues caused by self-referencing foreign key

Locking issues caused by self-referencing foreign key

From: Vsevolod Afanassiev <vafanassiev_at_yahoo.com>
Date: 18 Apr 2005 17:43:25 -0700
Message-ID: <1113871405.220944.142240@o13g2000cwo.googlegroups.com> 





I am probably stating the obvious - it appears that if:
1. A table has a self-referencing foreign key
2. There is no index on this foreign key
then Oracle would allow only one transaction against such table at a
time. Correct?
Received on Mon Apr 18 2005 - 19:43:25 CDT












Original text of this message













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