Re: Oracle Lock problem ! i really need help !

From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1996/11/14
Message-ID: <328BD3FC.7226_at_dt.com.hk>#1/1


Guillaume MAISON wrote:
> i have two tables A & B.
> B references A by a foreign key.
>
> On the first station, when i insert a row into table B, just before the
> insert, i run a stored procedure which insert a row in table A.
> but the commit isn't made immediatly.
> On the second station, i try to do the same thing On this second station,
 eveerything is stopped, waiting for the first
> station to commit or rollback.
>

You may create an index using foreign key fields on child table B.

-- 
Hui, Kwok Miu: Oracle DBA & Unix Administrator
               Cho Yang (Hong Kong) Co., Ltd.
email: huikomix_at_dt.com.hk
Tel  :(00852)2589 3369
Received on Thu Nov 14 1996 - 00:00:00 CET

Original text of this message