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 10.2.0.4 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.

Symptoms

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 10.2.0.4. This functionality is not possible if on version 10.2.0.3 and lower. This bug is included/fixed in the 10.2.0.5 patchset. Running imp help=y will not show the data_only option when patch is applied or when on 10.2.0.5, even though the data_only functionality is available
  • Migrate to 11.x from 10g.


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

Creating an xmltype column in 10.2.0.4:

Cause

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
Symptoms
Cause
Solution
References


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