I have a large Oracle 11g Instance. I now have a requirement to convert large amounts of XML into records in several related tables.
The xml will arrive frequently at irregular intervals. The documents will vary in size (100megs avg)
The XML is well defined and static in structure. The documents contains primary elements which should become the records. Each element has two child elements for related entries.
So for a element that looks like this
<element> <pet> <row0>1</row0> <row1>Dog</row1> <row2>Rex</row2> <row3>ownerRow3</row3> </pet> <owner> <row1>Bob</row1> <row2>banker</row2> <row3>1</row3> </owner> </element>
would be come one "row" in two tables.
What is the most reasonable ( time/money vs "best" ) solution for this relatively simple (and common) task ?
I am not opposed to writing my own "digester" but I do not want to overlook simple solutions ( commercial or free)
My familiarity with available Oracle tools is low and Web searches are not providing a reasonable answer.