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
1 ping
Log Buffer #226, A Carnival of the Vanities for DBAs | The Pythian Blog
24 June, 2011 at 9:15 (UTC 1) Link to this comment
[...] Marco blogs about a HowTo of XML partitioning and multiple XMLIndex structures. [...]