Re: Moving schemas between tablespaces

From: Annie STECZYCKI <armoni_at_club-internet.fr>
Date: Fri, 26 Jan 2001 10:50:45 +0100
Message-ID: <94rhd1$jg3$1@front5m.grolier.fr>

<mikeg12321_at_my-deja.com> a écrit dans le message : 94q926$9is$1_at_nnrp1.deja.com...
> Heres what I want to do:
> I want to create a new user and give him his own
> tablespace to store data. I want to export a
> schema from another user and import that schema
> into the new user's tablespace (so the new schema
> is owned by the new user). When I try to do this,
> the import always imports into the original
> tablespace, no matter that I set the touser=new
> user, and the new user's default tablespace is
> the new one I made for him. Any suggestions?
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/

before the import in the new_user, do "revoke unlimited tablespace from your_new_user_name";

so the import will be done in the new_user's default tablespace;

Annie STECZYCKI from FRANCE Received on Fri Jan 26 2001 - 03:50:45 CST