Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 22, 2013 4:55 AM by
Difference between "REBUILD ONLINE" and "REBUILD" while altering index
Apr 22, 2013 4:21 AM
Please go through this link.
Now if Rebuilding online enables you to update base tables at the same time that you are rebuilding, then when the base table is getting updated while Rebuilding without online option?
This content has been marked as final.
Show 1 reply
Re: Difference between "REBUILD ONLINE" and "REBUILD" while altering index
Apr 22, 2013 4:55 AM
in response to
I believe it work like this way
rebuild without online option => table and index is locked in exclusive mode preventing any translations on the table.
With online index rebuild, transactions can still access the table and index.