Home » RDBMS Server » Server Administration » Rebuild Index - Oracle 10g Rel2
Rebuild Index - Oracle 10g Rel2 [message #207389] Tue, 05 December 2006 05:59 Go to next message
deswal_sanjay
Messages: 4
Registered: May 2005
Location: Noida
Junior Member
Hi Everybody,

We knows that after truncating the partition index becomes invalid, so we need to rebuild the same. Is it true in Oracle 10g Rel 2 also. I'm not sure, can anybody clear this doubt.

- email : deswal_sanjay@yahoo.co.in


Regards,
sanjay
Re: Rebuild Index - Oracle 10g Rel2 [message #207393 is a reply to message #207389] Tue, 05 December 2006 06:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

http://www.dba-oracle.com/t_indexes_invalid_unusable.htm


hope this helps
Taj
Re: Rebuild Index - Oracle 10g Rel2 [message #208167 is a reply to message #207393] Fri, 08 December 2006 07:12 Go to previous messageGo to next message
deswal_sanjay
Messages: 4
Registered: May 2005
Location: Noida
Junior Member
Thanks
This is true Index become unbalanced after all such operation mentioned on this page. Is it true for Oracle 10g Rel2 also. This link does'nt clarifies it.

Regards,
sanjay
Re: Rebuild Index - Oracle 10g Rel2 [message #208264 is a reply to message #208167] Fri, 08 December 2006 22:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

Yes you have to rebuild ur index again if any partition of ur table you drop.

regards
Taj
Previous Topic: automatic startup on AS400
Next Topic: Gathering Satistics
Goto Forum:
  


Current Time: Sat Dec 10 10:47:32 CST 2016

Total time taken to generate the page: 0.07169 seconds