Global temporary tables with No logging
Date: Mon, 8 Jun 2009 05:14:43 -0700 (PDT)
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 !