From: Jim Smith <jim@jimsmith.demon.co.uk>
Subject: Re: Oracle Lock problem ! i really need help !
Date: 1996/11/11
Message-ID: <rGZTPDAaFzhyEwt3@jimsmith.demon.co.uk>#1/1
distribution: world
x-nntp-posting-host: jimsmith.demon.co.uk
references: <328495D3.4469@easynet.fr>
organization: At Home
mime-version: 1.0
newsgroups: comp.databases.oracle



In article <328495D3.4469@easynet.fr>, Guillaume MAISON
<maison@easynet.fr> writes
>Hi all !
>
>Before, i have to say that i'm quite new to Oracle...
>i'm using Oracle 7.0.16.6.5 on a Netware (3.12) server.
>
>
>after few searches, i've found that inserting into table A on the first
>station locks the entire table B, and so i can't do anything with table
>B from another station.
>

You should index your foreign key. This is a feature of Oracle where it
takes a table lock in certain circumstances if foreign columns are not
indxed.
-- 
Jim Smith