Re: any danger to set all indexes to nologging?

Yup.

Same thing is true of your entire database, as that is your sole option in NOARCHIVELOG mode...

on 5/20/03 1:01 PM, gmei at gmei_at_incyte.com wrote:

> Hi:
>
> We have an oracle 8173 db running in non-archive mode. I am thinking to set
> all indexes in application's schemas to "nologging" to reduce redo log
> writing. Is there any danger of doing that? I thought we could always
> rebuild them if there is anything wrong.
>
> TIA.
>
> Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).