Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Import bug ? (IMP-00015)

Import bug ? (IMP-00015)

From: Achille Carette <achyl_at_infonie.be>
Date: Fri, 9 Feb 2001 13:39:06 +0100
Message-ID: <3a83e4eb$0$20281$73bec57d@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:39:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US