Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Option NOLOGGING for indexes

Option NOLOGGING for indexes

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 13 Mar 2003 00:42:34 +0100
Message-ID: <nlav6v0dqt51de48516k3ethhvhgckb4fq@4ax.com> 





I would agree that in general, changes of valuable data in tables
should be done with the logging option. But what could be the
consequence of using the NOLOGGING option for indexes? One could set
this option at the tablespace level. It would be tolerable for me if
the index resulted being unusuable after an instance error, since it
is always possible to rebuild it. Or am I missing something?



Thanks


Rick Denoire
Received on Wed Mar 12 2003 - 17:42:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US