| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Any way to disable UNDO (rollback) with temporary tables?
Phil Kaufman <philk_at_dbcsmartsfotware.com> wrote in message news:<UZSdnUVl3qWPPE2iRVn-gg_at_golden.net>...
> 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.
> > 
> > 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
> 
> Since temporary tables have very similar characteristics to 'regular' 
> tables, then you need rollback data to maintain a consistent 
> table/database, or perhaps I am confused in this area.  To me it seems 
> reasonable to require rollback for temporary tables.
> 
> How would you handle a insert or update to the temporary table, with 
> respect to your transaction, if you didn't have rollback?
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 ecplecticosReceived on Fri Dec 05 2003 - 16:29:03 CST
|  |  |