HOWTO: XML Partitioning and Multiple XMLIndex Structures

Although not a “pure” XML partitioning example, that is partitioning data on criteria within the XML document, and before I forget to mention this exercise, I would like to point out the following URL:

http://forums.oracle.com/forums/thread.jspa?threadID=2234618

This small exercise was setup based on questions / comments from a reader on this blog regarding the ”
Structured XMLIndex (Part 3) – Building Multiple XMLIndex Structures” content after heaving trouble to setup structured and unstructured local XMLIndexes.

The forum link demonstrates howto:

• Register a XML Schema for use with Binary XML storage
• Create a RANGE partitioned table with a XMLType column (Binary XML Securefile storage)
• Create a Unstructured LOCAL Partitioned XMLIndex (UXI)
• Create multiple Structured local partitioned XMLIndexes (SXI)
• Create secondary indexes on the Content Tables created by the SXI structures
• The effects of different queries and their explain plan output making use of the UXI, SXI and partitioning

HTH