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

Daniel,

The problem was described in the original post. Basically we wanted to pass arrays of records back to pro*c, and in current implementation you'd have to fetch one by one, while fetching from a table (such as temporary) could be done in batches. Right now we're ditching Oracle arrays, and are going to pass everything back in one variable (limited to 32K in pl/sql), and parse it in pro*c. The reason for dealing with 'arrays' is to move some of the complex business logic into PL/SQL to avoid numerous sql*net roundtrips between db and client (pro*c).

-Andrey.

On Fri, 05 Dec 2003 14:58:34 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>Joel Garry wrote:
>
>
>> Why can't a temporary table use nologging if it doesn't need rollback
>> but real tables can?
>>
>> I think there are screwy things behind the scenes that Oracle won't
>> 'fess up to. We can only hope they are precursors to great things
>> coming and I am just Elmer FUD.
>>
>> jg
>> --
>> @home.com is bogus.
>> Colymbosathon ecplecticos
>
>Because that's not the way it was built.
>
>That is the best answer you are going to get.
>
>But lets get back to the point here ... you aren't being paid by your
>employer to re-engineer the RDBMS kernel in a relational database.
>
>What is the business problem?
>
>And whatever it is ... it has nothing to do with temp table rollback.
>
>--
>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 Mon Dec 08 2003 - 14:35:31 CST