Create index with online option (oracle)
232
Views
0
Comments
New
Database

Hi,

If we are creating an index in a table with a lot of values (millons of records) and the table have a lot of usage (it´ s a core table and have a lot of actions reading and writting), the deployment fails creating a index with timeout error, and all the deployment it´ s aborted on stage 2.
Also during the creation of the index the table have blocks and the users can´  t work.

If the index include "online" attribute in the creation, all this problems desapear.

Regards