Category: 11gR1, 11gR2
August 20

HOWTO: The Four Create Table statements for XML Binary Storage

The following simple create table examples demonstrate the four different ways to create XML Binary XML data storage. It demonstrates, in a simple way, how to create a table for XML Binary data storage.

  1. XML Table with a column based on Binary Storage

  2. XML Table with a column based on Binary Storage making use of a XML Schema (registered for binary use)

  3. XMLType Table based on Binary Storage

  4. XMLType Table based on Binary Storage making use of a XML Schema (registered for binary use)
Read the postHOWTO: The Four Create Table statements for XML Binary Storage
August 17

HOWTO: Create XMLType Table for Binary XML Usage

Binary XML storage can also be combined with an XML Schema. As shown in Mark Drakes presentation whitepaper (slide 6), the lower right of the diagram, shown below, marks the section for XML Schema (structured, schema based) binary XML storage.

Slide 6 of “Oracle Database 11g XML DB Presentation (PDF) July 2007”

XML Use Cases - Oracle Database 11g XML DB Presentation (PDF) July 2007, Mark Drake, Oracle

Click picture to enlarge

The following example will show how you can create an XMLType table making use of a defined XML Schema and how to avoid the ORA-44424 error (BINARY XML storage requires XML Schema registered for BINARY usage).

Read the postHOWTO: Create XMLType Table for Binary XML Usage
August 17

New XMLDB whitepapers and presentations were added on OTN