Re: Import bug ? (IMP-00015)

From: Achille Carette <achyl_at_infonie.be>
Date: Fri, 9 Feb 2001 13:47:14 +0100
Message-ID: <3a83ecff$0$26358$73bec57d@news.be.uu.net>

Sorry, i forgot : Oracle and import version are 8.1.6 on NT

"Achille Carette" <achyl_at_infonie.be> wrote in message news:3a83e4eb$0$20281$73bec57d_at_news.be.uu.net...
> A user has an unlimited quota on a the USERS tablespace, and on this one
> only - thus, all his objects are stored there.
>
> User is exported, dropped, and re-created with an unlimited quota on an
> ^other^ tablespace.
>
> At this time, the user doesn't own any object.
> When re-importing the dump, i get errors like :
>
> IMP-00015: following statement failed because the object already exists:
> ALTER TABLE .. ADD CONSTRAINT ..
> USING INDEX TABLESPACE USERS
>
> What's wrong ?
> Is there a solution or a workaround ?
>
> Thanks,
>
> Achille Carette
> achyl_at_infonie.be
>
>
Received on Fri Feb 09 2001 - 06:47:14 CST