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 LazyDBA home page