Re: exp and imp

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