Keep XML and relational data in same table space


You can choose to keep the XML and relational data in the same table space. This means they will be buffered in the same buffer pool. Within the table space, relational data is stored in DAT objects and XML data stored in XDA (XML data area) objects. You can store XML documents for up to 2 gigabytes in size in a database.

This default layout provides good performance for most application scenarios.

Operations


An example is shown on the right pane.
Note that the CREATE TABLESPACE statements may fail if they already exist in the database. If that's the case, you may ignore those errors.