Re: Rollback segment error - in SELECT statement ???

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 Sep 1999 14:10:20 +0100
Message-ID: <937920200.5587.1.nnrp-12.9e984b29@news.demon.co.uk>

Which error number ?

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Chetan Wagle wrote in message <7s7qfu$olh$1_at_herald.ctp.com>...
>
> A strange thing that I have noticed is that when I fire this select
>query when the billing is running, I get rollback segment errors. as per
>oracle, rollback segments are not used unless you perform some data
>manipulation - oracle says that a rollback segment gets allocated only when
>the first insert/update/delete statement comes along.
>
Received on Tue Sep 21 1999 - 08:10:20 CDT