Re: understanding rollback segments

....
>
> The "obvious":
>
> CREATE TABLE foo AS SELECT * FROM bar;
>

...

Try using the unrecoverable option with this. This does not write the redo, but I seem to have read somewhere that it also does not write rollback. (I am not totally sure on that though, but is probably worth a try)

--
Abhijit