Re: Temporary table use and the redo log

From: Robert Klemme <>
Date: Mon, 07 Sep 2009 18:35:36 +0200
Message-ID: <>

On 07.09.2009 18:23, wrote:
> Hi
> I'm using a global (session) temporary table to break up a section
> of a stored procedure that is needed in
> a number of places. Always for use in a select.
> If the database crashes, gets rolled back, anything, I don't care
> about the contents of that
> table. Especially -I don't want redo logs for it-. Is there any way I
> can accomplish this?
> From what I can see so far I should look into:
> - unrecoverable
> - insert /*+APPEND */ into temp_table select...
> - possibly using a table variable

I suggest to also look into ON COMMIT DELETE ROWS.

> Nologging is on by default for a tempory table but you still get some
> logging
> Am I on the right track?



remember.guy do |as, often| as.you_can - without end
Received on Mon Sep 07 2009 - 11:35:36 CDT

Original text of this message