Global temporary tables with No logging

  • From: walid alkaakati <walid_alkaakati@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 8 Jun 2009 05:14:43 -0700 (PDT)

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 !


Other related posts: