Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Import bug ? (IMP-00015)
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
![]() |
![]() |