Datapump Import (IMPDP) Does Not Import Table With XML Type Correctly (Doc ID 854642.1)

Last updated on SEPTEMBER 02, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.2.0.0
This problem can occur on any platform.

Symptoms

You will get following errors with Datapump impdp

ORA-39083: Object type TABLE:"OTN"."XMLTEST" failed to create with error:
ORA-12899: value too large for column "COST_CENTER" (actual: 16, maximum:
4000)
Failing sql is:
CREATE TABLE "OTN"."XMLTEST" ("PK" VARCHAR2(32 BYTE), "XML" "SYS"."XMLTYPE" ,
"COST_CENTER" VARCHAR2(16 BYTE) GENERATED ALWAYS AS (E
XTRACTVALUE(SYS_MAKEXML('1D4A490368E149869800DCC59E9D3164',4806,256,"SYS_NC000
03$"),'/PurchaseOrder/CostCenter')) VIRTUAL VISIBLE )
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOC
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Job "OTN"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:19:35

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