Table With XMLTYPE Column Lost Definition On XML SCHMEMA After Import

(Doc ID 2324565.1)

Last updated on JANUARY 03, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

A table has one column which is XMLTYPE datatype and uses an XMLSCHEMA for its definition.
After import to a target database the xmltype column definition is changed and there is no definition for the XMLSCHEMA.

Original column definition is:
XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/aaaa.xsd" Element "aaaa_bbb_ccc") STORAGE Object-relational TYPE "aaaa_bbb_ccc333_T"

After import the column definition is:
XMLTYPE STORAGE BINARY

 

On the source database, the DDL for table using package DBMS_METADATA shows similar behavior as with Data Pump:

The original column definition is:
XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/......
After import the column definition is:
XMLTYPE STORAGE BINARY


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms