在业务繁忙的时候我们需要创建索引,此时数据有DML操作,这时候我们如何做那?这时候online选项就有了用武之地。
create index xx on table (xx) online
oracle的官方文档讲述如下
You can create and rebuild indexes online. This enables you to update base tables at the same time you are building or rebuilding indexes on that table. You can perform. DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
我们知道,oracle在创建索引的时候,要为索引分配空间和索引数据,我们不加online的时候就会有DML,DDL锁,但是加了online,则DML锁没有了,只有DDL锁。这样就不会阻塞其它的用户的操作,顺利达到你创建索引的目的。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16674653/viewspace-694029/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16674653/viewspace-694029/