Re: Global temporary tables with No logging

Hi

If you have indexes on the GTT there will be redo


Thanks

--
LSC


On Mon, Jun 8, 2009 at 2:14 PM, walid alkaakati
<walid_alkaakati@xxxxxxxxx>wrote:

>
>
>  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: