On Mar 8, 3:24 pm, "Paul" <paulwragg2..._at_hotmail.com> wrote:
> 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
Sometimes increasing the buffer helps (BUFFER= keyword on imp
commandline) but as you don't specify the exact patchlevel: this
typically looks like a bug. If you are not running the latest patch
you might consider upgrading and/or submitting a SR.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Mar 08 2007 - 08:48:20 CST
