Andrew,

I think Ian is right!! According to Thomas Kyte, NOLOGGING only affects only
a few specific operations such as the initial creation of the object, or
direct path loads using SQLLDR, or rebuilds.

thanks to all reponses
peter.

>From: "Kerber, Andrew . MS-AK" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] RE: unrecoverable..for creating Index
>Date: Thu, 29 Aug 2002 16:23:41 -0500
>
>That is incorrect. If you create it nologging, no redo logs will be
>written
>for this index until you turn logging back on. However, rollback segments
>will always be written, so it doesnt gain you much.
>
>-----Original Message-----
>From: Ian [mailto:mcdonald.[Email Address Removed] Thursday, August 29, 2002 4:35 PM
>To: LazyDBA.com Discussion
>Subject: RE: unrecoverable..for creating Index
>
>
>Peter,
>
>The unrecoverable just means that while creating index the logging is
>suspended, after the index is built the normal rules for logging take
>affect
>again. As you rightly point out it just makes the index creation faster.
>If you are worried at all by the effect of no-logging do not use it, it's
>not mandatory. I always log my rebuilds as I have CPU power to spare!
>
>Over to you
>
>Cheers
>
>Ian
>
> -----Original Message-----
>From: Peter R [mailto:[Email Address Removed] 29 August 2002 20:43
>To: LazyDBA.com Discussion
>Subject: unrecoverable..for creating Index
>
>
>
>Hi Friends,
>
>
>Iam rebuilding my indexes! If I create my index as unrecoverable in Oracle
>7.3 on AIX, its nologging(redo) only for creating index!! or is it applies
>entire life of that index!! I have strong feeling its only for creating
>index! It will log any inserts for table!!some one list member told that
>its
>not persistent!!
>
>The whole idea is making faster for creating index, at the same time I
>should be able to recover if any problem arises!! I don't know how it
>works??
>
>Thanks
>peter.
>
>_________________________________________________________________
>Join the world's largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

Oracle LazyDBA home page