OraFAQ Forum: Performance Tuning » Index rebuild online

Home » RDBMS Server » Performance Tuning » Index rebuild online

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

Index rebuild online [message #488731]

Mon, 10 January 2011 15:24

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
What is the difference between index rebuild and index rebuild online.
Regards,
Varun Punj,

Report message to a moderator

Re: Index rebuild online [message #488732 is a reply to message #488731]

Mon, 10 January 2011 15:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Which part of the Posting Guidelines ( http://www.orafaq.com/forum/t/88153/0/ ) did you NOT read & follow?
Was it the part about using SEARCH ( http://www.orafaq.com/forum/s/136107/ ) or GOOGLE ( http://google.com ) before posting?
Why should we repeat here, what is already documented at http://tahiti.oracle.com
Please post DOCUMENTED solution back here after you have found it.

Report message to a moderator

Re: Index rebuild online [message #488733 is a reply to message #488731]

Mon, 10 January 2011 15:41

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_1010.htm#SQLRF00805

Quote:

ONLINE Clause

Specify ONLINE to allow DML operations on the table or partition during rebuilding of the index.

Report message to a moderator

Re: Index rebuild online [message #488735 is a reply to message #488733]

Mon, 10 January 2011 15:53

varunvir
Messages: 389
Registered: November 2007

Senior Member

Thanks Barbara

Report message to a moderator

Previous Topic:	Query taking time
Next Topic:	Query Taking too much time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 02:02:42 CST 2024