Yes, and in parallel for speed too if you like:

alter index <indexname> rebuild nologging parallel 20 ;
alter index <indexname> logging noparallel ;

Of course your new index will be lost if you need to restore/recover, so a
backup is recommended as soon as possible after this for a trouble free
recovery.

Take care if you use flashback too. If you do a flashback database to near
this point you may find "corrupt blocks". You may need to drop and recreate
in this case.



-----Original Message-----
From: Kopejtko Martin Ing.
[mailto:oracledba-ezmlmshield-x26429538.[Email address protected]
Sent: 28 December 2007 19:34
To: LazyDBA Discussion
Subject: rebuild of index

Hi,

can I rebuild index in archivelog mode without logging into redo logs?

Thanks a lot!
Martin
###########################################

Zprava byla pred odeslanim testovana systemem F-Secure Anti-Virus for
Microsoft Exchange.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page