Re: Moving schemas between tablespaces

> 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?

Import with show=y log=filename.sql. Modify as necessary Pre-create all objects in the new users schema Import with ignore=y

I don' t understand why the objects get created in the other tablespace? Can't you set the quota for this user on the other tablespace to 0, then give this user his own default tablespace and it will create the objects properly in the new tablespaces? I don' t know about this because I think the import will try to create them elsewhere and might error out without doing anything.

Good luck. Received on Thu Jan 25 2001 - 19:18:57 CST