Re: Preventing Inserting during updating subset

On Fri, 01 Nov 2002 00:09:21 -0500, C Chang <cschang_at_maxinter.net> wrote:

>How to prevent to insert a new row reacord into a subset of reacords
>while the subset is being updated. or vise versa prevent the subset to
>update while new row is inserted. Ex:
> A 1 new
> A 2 new
>update to
> A 1 old
> A 2 old
>prevent a 'A 3 new' insert into. The new row will become 'B 1 new',
>preventing subset of
> A 1 old
> A 2 old
> A 3 new
>what Oracle mechanism provides such thing. The only thing I can think
>about is to use the "For Update" in Updating block. Does it really
>achieve such goal? Thanks for anyone's suggestion.
>
>K Chang

Just lock table <table_name> in exclusive mode

for update doesn't prevent inserts.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Oct 31 2002 - 23:47:05 CST