OraFAQ Forum: Server Administration » Rebuild Index

Home » RDBMS Server » Server Administration » Rebuild Index - Oracle 10g Rel2

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

Rebuild Index - Oracle 10g Rel2 [message #207389]

Tue, 05 December 2006 05:59

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

Report message to a moderator

Re: Rebuild Index - Oracle 10g Rel2 [message #207393 is a reply to message #207389]

Tue, 05 December 2006 06:24

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

Report message to a moderator

Re: Rebuild Index - Oracle 10g Rel2 [message #208167 is a reply to message #207393]

Fri, 08 December 2006 07:12

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

Report message to a moderator

Re: Rebuild Index - Oracle 10g Rel2 [message #208264 is a reply to message #208167]

Fri, 08 December 2006 22:50

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

Report message to a moderator

Previous Topic:	automatic startup on AS400
Next Topic:	Gathering Satistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 02:53:05 CST 2025