From: emrynsoft@aol.com (Emrynsoft)
Subject: Re: understanding rollback segments
Date: 1997/05/05
Message-ID: <19970505192000.PAA23996@ladder01.news.aol.com>#1/1
References: <335EA149.B0E@_medicalert.org>
Organization: AOL http://www.aol.com
Newsgroups: comp.databases.oracle.server
X-Admin: news@aol.com



....
> 
> 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