Re: Global temporary tables with No logging

hi walid,
0) these temproray tables means what..intermediate tables for holding the data..
1) check the database with your dba that it allows to specify any table for logging and nologging, have look at the following link
http://www.adp-gmbh.ch/ora/misc/nologging.html
2) alter table xxx nologging/logging
3) yes global temprory table is one of the option and it depends how you want to use it I mean check the syntax, after the session it can loose the data or can keep the data etc..you may find some examples in the given llink 
http://www.oracle-base.com/articles/8i/TemporaryTables.php

thanks and take care..subodh

________________________________
From: walid alkaakati <walid_alkaakati_at_yahoo.com>
To: oracle-l_at_freelists.org
Sent: Monday, 8 June, 2009 17:44:43
Subject: 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 ! 



      

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