How to read UNCOMMITED data in Oracle?
From: francis70 <member41542_at_dbforums.com>
Date: Wed, 15 Oct 2003 01:10:57 -0400
Message-ID: <3482578.1066194657_at_dbforums.com>
Date: Wed, 15 Oct 2003 01:10:57 -0400
Message-ID: <3482578.1066194657_at_dbforums.com>
Hi,
I have these 2 problem? Is there a way in Oracle to read UNCOMMITED data. i.e. in Oracle the normal behaviour is that a user's updates to a table are visible to other users ONLY when the user commits. But in Informix there is this thing called ISOLATION LEVELS. For example by setting the ISOLATION LEVEL to DIRTY READ, a user will read dirty data, i.e. the last uncommited updated value of a field by some other user. Is this possible in Oracle by setting some parameter, say in the INIT file?
-- Posted via http://dbforums.comReceived on Wed Oct 15 2003 - 07:10:57 CEST