This content has been marked as final. Show 2 replies
The xml files we insert could be anywhere from 1MB to beyond 500MB+ in size, as it depends on the amount of audit data generated.Schema-based XMLType (aka Object-Relational or structure storage) is exactly what you need in this case.
- When you register a schema within the database, Oracle automatically creates a set of object types, collections and tables that map the XML structure to the SQL data model.
- When you insert an XML instance document in the schema-based table, the XML content is then stored in the underlying relational structure.
- When you issue queries against the XMLType table, for example using XQuery and XMLTable, Oracle automatically rewrites the query to access the relational objects where the data resides. This process results in very efficient queries whose performance compares to queries against regular tables. The Object-Relational structure also supports indexing.
The documentation has whole chapters about it :
Thanks for the response Odie.
We'll start using the XSD going forward.