Datapump Import (Impdp) Fails With Errors ORA-39083, ORA-922 (Doc ID 2098403.1)

Last updated on JANUARY 27, 2016

Applies to:

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

Symptoms

Datapump import fails with error ORA-39083 and ORA-922 like below:

Import: Release 12.1.0.1.0 - Production on Fri Jan 15 13:49:09 2016

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
Starting "SYS"."IMPDP_TEST": /******** AS SYSDBA parfile=impdpTEST.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 433.9 GB
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/LIBRARY/LIBRARY
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"DMS"."DOC_ATTR_CLOB" failed to create with error:
ORA-00922: missing or invalid option
Failing sql is:
CREATE TABLE "DMS"."DOC_ATTR_CLOB" ("DOC_ID" NUMBER NOT NULL ENABLE, "CLOB_ID" NUMBER NOT NULL ENABLE, "CLOBVALUE" CLOB DEFAULT NULL, "INSTANCE_ID" NUMBER DEFAULT NULL, "CREATED" DATE DEFAULT SYSDATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS
. . imported "DMS"."DOC_CONTENT" 0 rows

 

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