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 !


      

Other related posts: