Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp and imp
The other option is to pre-create the objects in the correct tablespace and do an import with ignore=y.
Byron Lee
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:959086952.13640.0.pluto.d4ee154e_at_news.demon.nl...
>
> roblop <roblop_at_friko2.onet.pl> schreef in berichtnieuws
> xPuW4.19400$zA1.489403_at_news.tpnet.pl...
> > I am using Oracl'e on NT and tools exp80 and imp80 to do copy of user.
Is
> > there a small problem. Default tablespace for user X i TBX and default
> > tablespace for user Y i TBY. I export user X to .dmp file.
> >
> > and i import
> >
> > imp80 grants=y full=n show=n indexes=y data=y fromuser=X touser=Y
> >
> > When import done, all tables belong to user Y will be in tablespace TABX
.
> > It's wrong. I want to tables belong to user Y will be in tablespace
TABY.
> >
> > How to do is?
> >
> > Roblop
> >
> >
> >
> >
> >
> >
> 1 make sure TABY is the default tablespace of user Y
> alter user Y default tablespace TABY
> 2 revoke unlimited tablespace /*privilege*/ from user Y
> 3 make sure user Y has quota on TABY and doesn't have quota on TABX
> alter user y quota unlimited on TABY quota 0 on TABX
> 4 Now run the import
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Tue May 23 2000 - 00:00:00 CDT