Global temporary tables with No logging

From: walid alkaakati <walid_alkaakati_at_yahoo.com>
Date: Mon, 8 Jun 2009 05:14:43 -0700 (PDT)
Message-ID: <792512.96928.qm_at_web65516.mail.ac4.yahoo.com>

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 !

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 08 2009 - 07:14:43 CDT

This message: [ Message body ]
Next message: Subodh Deshpande: "Re: Global temporary tables with No logging"
Previous message: Martin Klier: "String concat with hierarchical query and sys_connect_by_path(): Avoid ORA-30004?"
Next in thread: Subodh Deshpande: "Re: Global temporary tables with No logging"
Reply: Subodh Deshpande: "Re: Global temporary tables with No logging"
Reply: Goulet, Richard: "RE: Global temporary tables with No logging"
Maybe reply: Goulet, Richard: "RE: Global temporary tables with No logging"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message