OraFAQ Forum: Performance Tuning » Turn Logging on, on Index

Home » RDBMS Server » Performance Tuning » Turn Logging on, on Index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Turn Logging on, on Index [message #153048]

Wed, 28 December 2005 12:15

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 07:41:10 CST 2024