Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.cwix.com!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: jbradshaw777@yahoo.com (John)
Newsgroups: comp.databases.oracle.server
Subject: ORA-01555; does update/select sequence matter?
Date: 11 Nov 2003 15:19:29 -0800
Organization: http://groups.google.com
Lines: 11
Message-ID: <f2f59d82.0311111519.5c73b65@posting.google.com>
NNTP-Posting-Host: 164.109.144.90
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1068592769 11382 127.0.0.1 (11 Nov 2003 23:19:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 11 Nov 2003 23:19:29 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247478

Hi group,

Sanity check. 
1. There is no way to assign a rollback segment to a 'session', right?
2. It does not matter whether update or select comes first, ORA-01555
can potentially happen, rihgt?

Thanks.


John