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

I've read the book, and understand the functionality and importance. See my point below tough.

On Tue, 02 Dec 2003 13:29:54 -0500, Phil Kaufman <philk_at_dbcsmartsfotware.com> wrote:

>If I may quote the Oracle guru himself, Thomas Kyte, in his book expert
>one-on-one Oracle in a chapter called Redo and Rollback:
>
>"The most important things to take away from this chapter are the
>importance of redo and rollback, and the fact that they are not overhead
>- they are in fact integral components of the database, they are
>necessary and mandatory."
>
>Pick up a copy of the book, give a read, and listen to what Thomas and
>Daniel here are trying to tell you. ;-)
>
>NetComrade wrote:
>
>> 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
>

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