Re: Changing isolation level?

While stranded on information super highway Hans Forbrich wrote:
:)Hemant Shah wrote:
:)>
:)> While stranded on information super highway mcstock wrote:
:)> :)refer to the SET TRANSACTION statement in the SQL Reference manual
:)> :)
:)> :)relevant options are: ISOLATION LEVEL SERIALIZABLE and ISOLATION LEVEL READ
:)> :)COMMITTED (default)
:)> :)
:)> :)doesn't look like ISOLATION LEVEL SERIALIZABLE does what you want
:)> :)
:)> :)
:)> :)you'll also want to carefully review the sections on Data Concurrency and
:)> :)Consistency in the Concepts manual
:)> :)
:)>
:)> As others have mentioned, none of the isolation level will block readers.
:)> I will have to find some other way.
:)>
:)
:)Oracle des have IPC, pipes and other mechanisms to allow you to force
:)sync. Might help in this case.

Hmm. I will have to read-up on it.

Thanks.

-- 
Hemant Shah                           /"\  ASCII ribbon campaign
E-mail: NoJunkMailshah_at_xnet.com       \ /  --------------------- 
                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.           
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.