Re: Dirty reads

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 03 Oct 2000 16:07:30 -0400
Message-Id: <10638.118397@fatcity.com>

I don't think that Oracle would allow it because until the commit is = issued the other users see the "old" data and the user making the changes = sees the new data. If the user wants to see both copies of the data have = them login twice. One to make the changes and the other to view the = original data. To circumvent Oracle's method of data integrity would = destroy the foundation building blocks of the database ROR =AA=BF=AA
>>> turner_at_tellme.com 10/03/00 03:51PM >>>
Is there any way to say I want a select that won't look at the rollback segment? The user doesn't care if it's a dirty read.

Dave Turner

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: David Turner
  INET: turner_at_tellme.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 03 2000 - 15:07:30 CDT