Re: Error when importing

On Mar 8, 9:24 am, "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

You seem to be hitting bug 5557427.
When you use the keyword "DESC" in index creation, the index is considered to be a function based index.

BTW: There is as such nothing wrong with the create index statement that IMP is reporting. It just puts double quotes around each line. So to you it appears there is a wrong syntax related to double quotes, in reality its not true.

Anurag Received on Thu Mar 08 2007 - 10:41:53 CST