Re: Global temporary tables with No logging

From: Subodh Deshpande <>
Date: Mon, 8 Jun 2009 06:05:39 -0700 (PDT)
Message-ID: <>

hi walid,
0) these temproray tables means what..intermediate tables for holding the data..
1) check the database with your dba that it allows to specify any table for logging and nologging, have look at the following link
2) alter table xxx nologging/logging
3) yes global temprory table is one of the option and it depends how you want to use it I mean check the syntax, after the session it can loose the data or can keep the data may find some examples in the given llink

thanks and take care..subodh

From: walid alkaakati <>
Sent: Monday, 8 June, 2009 17:44:43
Subject: Global temporary tables with No logging

Hallo list,

i have an application that uses about 60 Temporary tables, the problem is that each day we i have more than 500 Mb as an increase in Archive logs.

How can i specify No Logging option for these Temporary tables ?  when i try i get a syntax error, also i have read in one blog that Global temporary tables do Not Genrate Redo, so can some one please clarify the truth ?

Thank you all ! 

Received on Mon Jun 08 2009 - 08:05:39 CDT

Original text of this message