Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: rsanjaynj@yahoo.com (Sanjay Raj)
Newsgroups: comp.databases.oracle.server
Subject: Re: select e rollback segment
Date: 24 Apr 2002 11:29:38 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <9f767483.0204241029.444611d0@posting.google.com>
References: <aa6f6d$590$1@fe1.cs.interbusiness.it>
NNTP-Posting-Host: 196.3.51.241
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1019672978 8347 127.0.0.1 (24 Apr 2002 18:29:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 24 Apr 2002 18:29:38 GMT
Xref: easynews comp.databases.oracle.server:144411
X-Received-Date: Wed, 24 Apr 2002 11:27:17 MST (news.easynews.com)

"Renato" <rsimonetto.bis@NONFARMISPAMreplay.it> wrote in message news:<aa6f6d$590$1@fe1.cs.interbusiness.it>...
> the query with a SELECT statement use the rollback segment? I execute a
> query on Oracle 7.3.4 and the programme gave me the error: "snapshoot too
> old: rollback segment NAME too small (ORA 01555)"

Use the following command at the beginning of the script ( First line)

SET TRANSACTION USE ROLLBACK SEGMENT <name>;

Thanks