Re: Import bug ? (IMP-00015)

In article <3a83ecff$0$26358$73bec57d_at_news.be.uu.net>,   "Achille Carette" <achyl_at_infonie.be> wrote:
> 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
> >

The import is trying to rebuild the user objects back in the tablespace they were exported from. If you want to relocate the user objects you need to generate the code and re-create the tables after you export the user and drop the user but before you run the import. Then set the ignore=y parameter on the import to reload the data into the new table.

An alternate method for version 8.1 and up is to use the alter table move command to move the table.

>

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/