From: Rupesh Kapoor <rupesh@parsecweb.com>
Subject: Read only transaction
Date: 1996/02/20
Message-ID: <4gbelg$pti@alterdial.UU.NET>#1/1
content-type: text/plain; charset=us-ascii
organization: PARSEC Communications
x-url: news://alterdial.uu.net/comp.databases.oracle
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 1.12 (X11; I; SunOS 5.5 sun4m)


Hi,
	I'm trying to enumerate a table with 3 fields, one of them indexed.
I type the following commands *immediately after starting sqlplus monitor*

set transaction read only;
select field from table;

	After about 50,000 responses, I get an error 01555 snapshot too old (rollback
segment too small) Why does oracle need rollback space for a read only
transaction? Also, if I have exactly one client manipulating a table, can I ask
oracle not to use rollback space (auto commit) for a read-write transaction?

Thanks
Rupesh