Unable To Import Certain Tables Using Conventional Import (IMP) Error ORA-922 Missing Or Invalid Option

(Doc ID 1206324.1)

Last updated on FEBRUARY 08, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 08-FEB-2013***

Symptoms

The Import utility fails to import certain tables with an ORA-922 error:

. . importing table "BERTHS" 15915 rows imported
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "M_NODE_303" ("UNIQID" NUMBER(12, 0), "IMPORT" NUMBER(2, 0), ""
"OWNSHP" NUMBER(1, 0), "LASTOP" NUMBER(1, 0), "GRADEL" NUMBER(1, 0), "EMIN_X"
"" NUMBER(2, 0), "EMIN_Y" NUMBER(10, 6), "SHAPE" "MDSYS"."SDO_GEOMETRY") PC"
"TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE "S57_FEATURES_01" N"
"OCOMPRESS NOT SUBSTITUTABLE AT ALL LEVELS PARTITION BY RANGE ("GRADEL" , ""
"EMIN_X" , "EMIN_Y" ) (PARTITION "PT_303_G4_175W55N" VALUES LESS THAN (9, 1"
....
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option

Pre-creating table did not get around the errors either.

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