Re: Oracle Lock problem ! i really need help !
From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/11/11
Message-ID: <rGZTPDAaFzhyEwt3_at_jimsmith.demon.co.uk>#1/1
Date: 1996/11/11
Message-ID: <rGZTPDAaFzhyEwt3_at_jimsmith.demon.co.uk>#1/1
In article <328495D3.4469_at_easynet.fr>, Guillaume MAISON
<maison_at_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 SmithReceived on Mon Nov 11 1996 - 00:00:00 CET