Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Any way to disable UNDO (rollback) with temporary tables?

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

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 01 Dec 2003 21:21:53 GMT
Message-ID: <3fcbae42.3308052187@nyc.news.speakeasy.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US