Re: Import bug ? (IMP-00015)

Paul,

Thanks for your answer.

In fact, i'm not trying to relocate objects of an existing user (wich could be done using the MOVE command), but to create a duplicate of an existing one in another tablespace - for testing purposes.

(1) I export the existing user, wich has USERS as default tablespace (and quota on this tablespace only)

Exp User1/Password1_at_ConnectString

(2) Create the new user with an other default tablespace

Create user User2

    identified by Pwd2
    default tablespace NewTablespace
    quota unlimited on NewTablespace;
Grant connect, resource to User2;
Revoke unlimited tablespace from User2;

(3) Import the User1 schema objects into User2

imp system/pwdsystem_at_ConnectString fromuser=User1 touser=User2 file=expdat

Wich causes this IMP-00015 error

(In export version 7.3.4, this worked without problem)

"Paul Harrington" <paulh_at_io.com> wrote in message news:3A8405A5.19FBC9A7_at_io.com...
> Achille,
>
> First of all, it seems that what you are trying to do here essentially is
 move
> tables from one tablespace to another. This you can do in 8.1.6 with the
> following:
>
> ALTER TABLE tbl_name MOVE TABLESPACE new_tablespace
>
> About your import problem... what you are doing should work if you do
> something like this:
> * Export
> * Remove quota on the USERS tablespace (ALTER USER ... QUOTA 0 ON USERS)
> * Assign new default tablespace, and assign quota on the new tablespace
> * Import
>
> If none of the above works for you perhaps you might post more details,
 such
> as the imp/exp command parameters.
>
> Paul.
>
> Achille Carette 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
> > >
> > >
>
> =====================================================================
> Paul Harrington - Oracle DBA/Developer, Orbiscom, Dublin.
> Email: paulh_at_io.com. Please note: I discard all BCC messages unread.
> =====================================================================
>
>
Received on Fri Feb 09 2001 - 09:49:32 CST