Re: select e rollback segment

From: Sanjay Raj <rsanjaynj_at_yahoo.com>
Date: 24 Apr 2002 11:29:38 -0700
Message-ID: <9f767483.0204241029.444611d0@posting.google.com>

"Renato" <rsimonetto.bis_at_NONFARMISPAMreplay.it> wrote in message news:<aa6f6d$590$1_at_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 Received on Wed Apr 24 2002 - 13:29:38 CDT