Re: Can a SELECT statement build up a rollback segment?

What happens if you're doing a group by and/or an order by, and your temporary tablespace is one that's not marked as temporary?

Adam Danieluk wrote:

> SELECT don't build rollback segment,
> because select don't change database.
>
> johnvue_at_gte.net wrote:
> >
> > Can a SELECT statement build up a rollback segment?
> >
> > Obviously, INSERT, UPDATE, and DELETE do but is there any way that
> > SELECT query would build up rollback space. Of course, SELECT query
> > may _use_ a rollback for read consistency... but that's not the same
> > thing as building up rollback space.
>
> --
> Adam Danieluk
> ----------------------------------------------
> e-mail: adanielu_at_natned.com.pl
> ----------------------------------------------
Received on Wed Aug 05 1998 - 16:09:59 CDT