My Oracle Support Banner

Change in Default Storage Model of XMLType to Binary XML in (Doc ID 1207893.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


The purpose of this note is to detail the changes made to the default storage model for the XMLType datatype in release and explain how this will effect Oracle customers and Oracle Global Product Support.


The note is intended for all Oracle users and developers that develop using the XMLType datatype, for all Oracle users that rely on traditional export and import for databases that contain the XMLType datatype and for all support engineers that may be running a test case with the XMLType datatype.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Default Storage Model for XMLType
 Default LOB Storage for Binary XML
 How will this effect XMLTYPE tables and/or that existed before upgrade?
 How will this effect existing applications that deploy against the new version?
 How will this effect existing deployment scripts ?
 How do I modify my create statement to make a CLOB based XMLType table and/or column?
 Are there any other items that can influence the underlying storage characteristics of XMLType?
 How can this effect maintenance and Support on the Oracle database?
 EXP and IMP usage.
 Creating and/or running a test case for a support issue.
 Is there anything else I should know about binary XMLType?
 Does the XMLTYPE method getclobval return the same results from the same XML data in each storage model?
 What if the database is using the DICOM and/or Oracle Applications Express(APEX) features.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.