tag:blogger.com,1999:blog-19771507.post113575691300112850..comments2024-03-12T04:35:02.979-07:00Comments on Jaffar's (Mr RAC) Oracle blog: Index Rebuild Part IThe Human Flyhttp://www.blogger.com/profile/03489518270084955004noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-19771507.post-63533024801517110822010-12-13T07:00:00.017-08:002010-12-13T07:00:00.017-08:00Thanks for your blog post. It is is best explanati...Thanks for your blog post. It is is best explanation I found about inxex rebuild online vs offline.ARnoreply@blogger.comtag:blogger.com,1999:blog-19771507.post-47510803733570274762010-04-14T20:51:43.941-07:002010-04-14T20:51:43.941-07:00Dear jaffer,
I will be running a Index rebuild of...Dear jaffer,<br /><br />I will be running a Index rebuild of 6 Indexes whose size is around 1 TB, ur explanation is very neat, Iam planning to run this from 3 nodes parallely, since it doesn not scan the base table I hope there wouldnt be any interconnect bottleneckAsadhttps://www.blogger.com/profile/17492939323131073130noreply@blogger.comtag:blogger.com,1999:blog-19771507.post-60224549286631924452008-08-23T11:34:00.000-07:002008-08-23T11:34:00.000-07:00I appreciated your explanation -- thank you! So, ...I appreciated your explanation -- thank you! <BR/><BR/>So, an online rebuild DOES reference the base table? In other words, if I take an export in database 1 (indexes=n) and then truncate the tables in database 2, import the data, and then do an "alter index rebuild online" -- it should rebuild the indexes based on the current data in the tables. Am I correct?Anonymousnoreply@blogger.com