Srini Chavali wrote:Note: Keep in mind that the time that it takes on online index build to complete is proportional to the size of the table and the number of concurrently executing DML statements. Therefore, it is best to start online index builds when DML activity is low.
How many rows are in the table ? What is the database version ? One possible option is to create the index online, while the upgrade is running.