Global temporary tables with No logging

From: walid alkaakati <>
Date: Mon, 8 Jun 2009 05:14:43 -0700 (PDT)
Message-ID: <>

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 - 07:14:43 CDT

Original text of this message