Forum Stats

  • 3,854,516 Users
  • 2,264,375 Discussions
  • 7,905,714 Comments

Discussions

How to create or alter an unstructured XML index online

3236329
3236329 Member Posts: 4
edited Jun 13, 2016 8:28AM in MySQL Community Space

Hi,

While creating or altering an unstructured XML index in Oracle 12.1, queries and inserts have to wait until index creation or alteration is complete. This blocking behavior is not acceptable as it requires a huge maintenance window when the index is initially created. Depending on the amount of data to be indexed, index creation can take many hours or even days.

Looking for solution to create the XML index online without locking the base table.

Chandan

Best Answer

Answers