rebuild index online locks dml
694352Jul 14 2009 — edited Jul 14 2009Hello
I did some test, and notice that
Rebuilding indexes online, still locks dml. Am I right?
SQL>CREATE TABLE test (test number(3));
Table created.
SQL> CREATE INDEX test_ind ON test(test);
Index created.
*** In other session (2)
SQL> INSERT INTO test VALUES (10);
1 row created.
*** In the original session (1)
SQL> ALTER INDEX test_ind REBUILD ONLINE;
*** session hangs (due to session 2)
*** In another session (3)
SQL> INSERT INTO test VALUES (11);
*** It now hangs due to lock from session 1