Re: Any way to disable UNDO (rollback) with temporary tables?

NetComrade wrote:

> I kind of understand the reason behind storing undo for temporary
> tables, but in our case, I believe we just don't need it.

You may well believe it but you are incorrect in that bleief.

The entire structure of Oracle is based on an architecture that does. Your belief that you don't is irrelevant to the underlying database engine.

Whatever UNDO is doing ... it is undoubtedly not your problem. I would suggest you concentrate on what is.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)