Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Any way to disable UNDO (rollback) with temporary tables?
I kind of understand the reason behind storing undo for temporary
tables, but in our case, I believe we just don't need it.
We are using temporary tables as 'arrays', since it seems like Oracle cannot pass back (in bulk) arrays of objects back to Pro*C. So we do a lot of logic within PL/SQL, and populate a generic temporary table, and then fetch from it in Pro*C. However, the overhead of writing UNDO (and extra CPU processing that comes with it) seems unnecessary. I looked at various 'events', but none of them seem to offer what we need.
Any way this could be done?
Thanks
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Mon Dec 01 2003 - 15:21:53 CST
![]() |
![]() |