Error when importing

Hi,

I have a database dump exported from Oracle 10. When importing in to a new user I get the following error:

IMP-00017: following statement failed with ORACLE error 942:
"CREATE UNIQUE INDEX "IX1_TABLE1" ON "TABLE1" ("GROUPID" DESC "
", "INCEXCID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL
65536 FR"
"EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TABLE1"
LOG"
"GING"

IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist

Now, I know exactly why this error occurs - it is due to the double quotes that Oracle has included in the CREATE INDEX statement. I can quite happily remove these so that the spacing is correct as below:

CREATE UNIQUE INDEX "IX1_TABLE1" ON "TABLE1" ("GROUPID" DESC, "INCEXCID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TABLE1" LOGGING This works fine. We have 430 indexes in the DB, yet this is the only one that fails to be created. All I can see is that the CREATE INDEX statement is being generated incorrectly by Oracle.

Does anybody have any ideas how I can stop this from happening? It may seem quite trivial but as we regularly do imports/exports it will become annoying!

Any help is greatly appreciated.

Thanks,

Paul Received on Thu Mar 08 2007 - 08:24:29 CST