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 !
- Follow-Ups:
- Re: Global temporary tables with No logging
- From: Subodh Deshpande
- RE: Global temporary tables with No logging
- From: Goulet, Richard
- Re: Global temporary tables with No logging
- From: LS Cheng
- Re: Global temporary tables with No logging
Other related posts:
- » Global temporary tables with No logging - walid alkaakati
- » Re: Global temporary tables with No logging - Subodh Deshpande
- » RE: Global temporary tables with No logging - Goulet, Richard
- » RE: Global temporary tables with No logging - David Kurtz
- » Re: Global temporary tables with No logging - LS Cheng
- » RE: Global temporary tables with No logging - Michael Rosenblum
- » RE: Global temporary tables with No logging - Goulet, Richard
- » RE: Global temporary tables with No logging - Michael Rosenblum
- » RE: Global temporary tables with No logging - Goulet, Richard