Home » RDBMS Server » Performance Tuning » Turn Logging on, on Index
Turn Logging on, on Index [message #153048] Wed, 28 December 2005 12:15 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I rebuild a index
alter index owner.index_name rebuild tablespace tablespace_name parallel 4 nologging;

Is the syntax above correct, If yes, how do I turn the logging back on.

Thanks
Toshi

Report message to a moderator

Re: Turn Logging on, on Index [message #153354 is a reply to message #153048] Sat, 31 December 2005 23:26 Go to previous message
waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia
Junior Member
Hai,

S the syntax is correct. See the following is the output got to me...

SQL> alter index PK_EMP_EMPNO rebuild tablespace USERDATA parallel 4 nologging;

Index altered.


To enable logging do the following....

SQL> alter index PK_EMP_EMPNO rebuild tablespace USERDATA parallel 4 logging;

Index altered.

######### OR ##########

SQL> alter index PK_EMP_EMPNO rebuild tablespace USERDATA parallel 4;

Index altered.

Report message to a moderator

Previous Topic: Error In Analyzing Table (Ora-03114 & ORA-00603)
Next Topic: Shrinking Index tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 12:41:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.