EXP-00107: Feature (BINARY XML) reported when using original Export in 11.2 (Doc ID 1401358.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2014***

Symptoms

XMLType is an abstract data type, so it is straightforward to create an XMLType table or column. The basic CREATE TABLE statement, specifying no storage options and no XML schema, stores XMLType data as binary XML.

The XMLType storage model for XML schema-based data is whatever was specified during registration of the referenced XML schema. If no storage model was specified during registration, then binary XML storage is used.

When exporting such object with original Export utility the following errors will be reported:

EXP-00107: Feature (BINARY XML) is reported when the following object types are exported:
  • Tables of XMLType
  • Tables with an XMLType Column

 

EXP-00112: and EXP-00078: are reported additionally, when exporting:
  • Tables with an XMLType column which is using a xmlindex


The following test case will illustrate this in more detail:

TEST CASE
=========
drop table tc1.t1_xmltype_table;
drop table tc1.t2_xmltype_column;
drop table tc1.t3_xmltype_column_xmlindex;

-- Creating a Table of XMLType
create table tc1.t1_xmltype_table
of xmltype xmltype store as binary xml;

-- Creating a Table with an XMLType Column
create table tc1.t2_xmltype_column (c1 xmltype, c2 number);

-- Creating a Table with an XMLType Column using an xmlindex
create table tc1.t3_xmltype_column_xmlindex (c1 xmltype, c2 number);
create index tc1.t3_idx on tc1.t3_xmltype_column_xmlindex(c1)
indextype is xdb.xmlindex;



Table Description
=================
descr tc1.t1_xmltype_table

Name                             Null? Type
----------------------------- -------- --------------------
TABLE of XMLTYPE STORAGE BINARY


descr tc1.t2_xmltype_column

Name                    Null? Type
-------------------- -------- ------------------------
C1                            XMLTYPE STORAGE BINARY
C2                            NUMBER


descr tc1.t3_xmltype_column_xmlindex

Name                    Null? Type
-------------------- -------- ------------------------
C1                            XMLTYPE STORAGE BINARY
C2                            NUMBER



Export Errors
=============

Exporting a Table of XMLType
----------------------------
exp tc1/****** file=d:\exp2.dmp tables=t1_xmltype_table

Export: Release 11.2.0.2.0 - Production on Sun Jan 29 20:46:30 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table T1_XMLTYPE_TABLE
EXP-00107: Feature (BINARY XML) of column SYS_NC_ROWINFO$ in table TC1.T1_XMLTYPE_TABLE is not supported. The table will not be exported.
Export terminated successfully with warnings.




Exporting table using a XMLType Column
--------------------------------------
SQL> host exp tc1/****** file=d:\exp2.dmp tables=t2_xmltype_column

Export: Release 11.2.0.2.0 - Production on Sun Jan 29 20:46:31 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table T2_XMLTYPE_COLUMN
EXP-00107: Feature (BINARY XML) of column C1 in table TC1.T2_XMLTYPE_COLUMN is not supported. The table will not be exported.
Export terminated successfully with warnings.



Exporting a Table with an XMLType Column using an xmlindex
----------------------------------------------------------
SQL> host exp tc1/****** file=d:\exp2.dmp tables=t3_xmltype_column_xmlindex

Export: Release 11.2.0.2.0 - Production on Sun Jan 29 20:46:32 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table T3_XMLTYPE_COLUMN_XMLINDEX
EXP-00107: Feature (BINARY XML) of column C1 in table TC1.T3_XMLTYPE_COLUMN_XMLINDEX is not supported. The table will not be exported.
EXP-00112: Index T3_IDX is of XMLType and could not be exported
EXP-00078: Error exporting metadata for index T3_IDX. Index creation will be skipped
Export terminated successfully with warnings

Changes

Original Export utility was used for exporting tables.

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