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

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 6 Dec 2003 09:50:13 +1100
Message-ID: <3fd10ba6$0$20482$afc38c87@news.optusnet.com.au>

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0312051429.2addca1_at_posting.google.com...

>
> Why can't a temporary table use nologging if it doesn't need rollback
> but real tables can?

Because they're created in temporary tablespace, and don't generate their own redo anyway?

A bit like, why can't you say "alter index blah coalesce online"? Because coalescing is intrinsically an on-line operation, so the qualifier is redundant.

Just a thought.

Regards
HJR
> 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
Received on Fri Dec 05 2003 - 16:50:13 CST