I have performed a full and user database export successfully. When I try and import the file, whether just a table or complete user, the Oracle error 922 is received. I've pasted the script from the import. If I just use SQL and run the script, without the "'s, it works fine. I am trying to import this into a different database that has the same user and tablespaces as the source.

I want to use export/import as a process to perform backups of the database. I did not shutdown the database during the export process.

Here's the error and scripting.

Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing SYSTEM's objects into SYSTEM
. importing OCC's objects into XXX
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "CT_LOCATION_TAB" ("CT_LOCATION_CODE" NUMBER(2, 0) NOT NULL EN"
"ABLE, "LAST_TICKET_NUMBER" NUMBER(8, 0), "LAST_TICKET_DATE" DATE, "LAST_TIC"
"KET_TIME" NUMBER(6, 0), "MAX_TICKET_NUMBER" NUMBER(8, 0), "LAST_LOAD_ORDER_"
"NUMBER" NUMBER(6, 0), "MAX_LOAD_ORDER_NUMBER" NUMBER(8, 0), "CREATED_BY" VA"
"RCHAR2(30) NOT NULL ENABLE, "MODIFIED_BY" VARCHAR2(30) NOT NULL ENABLE, "CR"
"EATION_DATE" DATE NOT NULL ENABLE, "MODIFICATION_DATE" DATE NOT NULL ENABLE"
", "PRODUCER_CONFIGURATION" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPAC"
"E "IOMS_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option



Thanks for any help.