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
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 3369Received on Thu Nov 14 1996 - 00:00:00 CET