Alter index with nologging option
614497Apr 14 2008 — edited Apr 14 2008Hi all,
Our DB is 10g and db server is MS window 2003 server. The past weekend I tried to rebuild indexes for several schemas but generate huge amount of archive logs so that my db hang because the space issue. I have used the statements like the following:
ALTER INDEX schema_name.index_name REBUILD ONLINE NOLOGGING;
I thought with nologging option it should not generate any archive log at all. So my questions come:
1) Is the statement syntactically correct?
2) Is the option 'NOLOGGING' really work?
Thanks a lot in advance for your kind help,
Shirley