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

Possibly you're right.. But I just couldn't come up with a scenario where my temporary data would be need to recover any transaction.. If instance or session fails, data should just be discarded, as any data stored in temporary data is not used for anything but fetching it (e.g. it's not inserted in any 'real' tables).

The best solutions for us to to pass damn object arrays back to Pro*C, but Oracle just doesn't seem to be able to do it, or at least that's what they tell us.

On Tue, 02 Dec 2003 08:44:42 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Dec 02 2003 - 11:19:45 CST