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

Locking

From: Grzesiek Gizinski <Grzegorz.Gizinski_at_softax.com.pl>
Date: Tue, 22 Jun 1999 21:28:55 +0200
Message-ID: <376FE3F7.641C4B26@softax.com.pl>


Hi Everybody,

After some experiences I've found out that insert and update operations on the same table are non blocking. I'm using trasaction replication tool based on db locks. So, when insert and update oparations will not be performed in the same order on both nodes - I will get incosistance. The question is: how to set Oracle to make these operations block each other?

TIA
Grzesiek Received on Tue Jun 22 1999 - 14:28:55 CDT

Original text of this message

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