How to create or alter an unstructured XML index online

3236329

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

lefred-MySQL-Oracle

Hi,

I think you should have more chance posting this question in the dedicated Oracle forum instead of MySQL ;-)

Best regards,

lefred-MySQL-Oracle

Hi,

I think you should have more chance posting this question in the dedicated Oracle forum instead of MySQL ;-)

Best regards,