Ah yes, Thank you, now reminded of the correct info I suddenly remember (to
late), I'll get my coat!!
-----Original Message-----
From: Kerber, Andrew . MS-AK [mailto:[Email Address Removed] 29 August 2002 22:24
To: 'Ian'
Cc: LazyDBA. com Discussion (E-mail)
Subject: RE: unrecoverable..for creating Index
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 LazyDBA home page