Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> isolation levels - I think?

isolation levels - I think?

From: Adam Turner <ATurner_at_concreteinc.com>
Date: Wed, 18 Oct 2000 08:35:06 -0400
Message-Id: <10653.119625@fatcity.com>


I have a developer trying to do a multi table update on the database that contains one begin and one commit at the end. In theory we are trying to update all of these tables - without changing the data accessed by the rest of the application until the commit. This means that there should be no change ... then a commit .. then new data should be seen. Instead we are seeing partially updated tables and data throughout the update process.

I am new to Oracle, and I must admit I don't exactly know what is going on here. Do I need to change the isolation level of the updates - or of the reads to achieve the desired result?

thanks Received on Wed Oct 18 2000 - 07:35:06 CDT

Original text of this message

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