DataPump Import (IMPDP) Fails With Error ORA-22851

(Doc ID 1498993.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.

Symptoms

During importing a GLOBAL TEMPORARY TABLE with an XMLTYPE column IMPDP fails with errors:

...
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-22851: invalid CHUNK LOB storage option value
Failing sql is:
CREATE GLOBAL TEMPORARY TABLE "TC1"."PO_TAB" ("XML" "SYS"."XMLTYPE" ) ON
COMMIT DELETE ROWS XMLTYPE COLUMN "XML" STORE AS BASICFILE CLOB  (ENABLE
STORAGE IN ROW CHUNK NaN PCTVERSION 10 NOCACHE NOLOGGING )  XMLSCHEMA
"http://www.oracle.com/PO.xsd" ELEMENT "PurchaseOrder" ID 4820

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