OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Index rebulding (Linux 2.6.18-92.1.13.el5)

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

Index rebulding [message #538347]

Thu, 05 January 2012 07:07

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

I am working on Index issue and need to validate the structure of the index. Please confirm, does validation lock the Index ?

Do we need downtime or we can do it in normal working hours.

alter index index_name validate structure;

Thanks

Report message to a moderator

Re: Index rebulding [message #538348 is a reply to message #538347]

Thu, 05 January 2012 07:10

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Please confirm, does validation lock the Index ?

Yes.

The second question is up to you.

Regards
Michel

Report message to a moderator

Re: Index rebulding [message #538350 is a reply to message #538348]

Thu, 05 January 2012 07:28

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Michel.

I will be looking for free on the server.

Report message to a moderator

Re: Index rebulding [message #538790 is a reply to message #538347]

Mon, 09 January 2012 08:41

LNossov
Messages: 318
Registered: July 2011
Location: Germany

Senior Member

I suppose, you mean ANALYZE, not alter.

There is an ONLINE option for validate structure.

Report message to a moderator

Re: Index rebulding [message #538791 is a reply to message #538790]

Mon, 09 January 2012 08:52

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I do not see any ALTER word in this topic (but yours).

Thanks for the ONLINE option.

Regards
Michel

Report message to a moderator

Re: Index rebulding [message #538794 is a reply to message #538347]

Mon, 09 January 2012 08:55

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Michel:

dba_7722 wrote on Thu, 05 January 2012 13:07

alter index index_name validate structure;

Report message to a moderator

Re: Index rebulding [message #538811 is a reply to message #538794]

Mon, 09 January 2012 10:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I'm blind today! /forum/fa/1606/0/

Regards
Michel

Report message to a moderator

Re: Index rebulding [message #538920 is a reply to message #538811]

Tue, 10 January 2012 06:42

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Sorry Michel,

It was mistakenly written 'alter'.

May i please ask what is difference between analyze index with online option and without. I read with online option,no statistics are gathered, the process only validates the integrity of the object.

Report message to a moderator