Online Create Index

  • Thread starter Thread starter eduardosyc
  • Start date Start date
Status
Not open for further replies.
E

eduardosyc

Guest
The online create index in concurrent operations fails with "Failure to acquire exclusive schema lock for DDL operation. (7872)" error. Ok, it is possible to create inactive indexes for an online database however, this is not really workable. PROUTIL IDXACTIVATE notes If IDXACTIVATE detects clients with an earlier schema timestamp than the index, you may wait for those clients to disconnect or forcibly disconnect them with PROSHUT. IDXACTIVATE can not complete and activate the index until the clients with an earlier schema timestamp are disconnected from the database. PS.: Case 00322552

Continue reading...
 
Status
Not open for further replies.
Back
Top