My Oracle Support Banner

How to move XML schema based xmltype data from 10g to another schema/migrate to 11g (Doc ID 1318012.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


Customers who make use of schema based XMLType tables/columns in 10g need to have the capability to:

  • Move XMLType data from one database schema to another database schema in the same or different database instances. Please note, if you intend to move between 10g instances, you will need to apply patch for bug:5247029 if on This functionality is not possible if on version and lower. This bug is included/fixed in the patchset. Running imp help=y will not show the data_only option when patch is applied or when on, even though the data_only functionality is available
  • Migrate to 11.x from 10g.

The following example demonstrates moving XML schema based data from from user xdb11 to a database to user xdb55.

Creating an xmltype column in


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

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