Can an Oracle index be created in a low priority thread/process?

We're all working on the same development database at the same time. Usually t开发者_开发技巧his is not a problem, but sometimes we need to create a new index on one of the huge tables. This slows down the database for everyone.

Is there a way to create an index in a low-priority Oracle process, such that the other developers can continue working?

create index ... online ?

I think that is exactly what the ONLINE keyword is supposed to do. There may be some impact, but you should be able to continue working with the table.

You can:

• use the resource manager to create a resource plan that will limit the throughput of the process
• use nice or ionice on the process to reduce its priority at the OS level
• if you use the enterprise edition then you can create the index online