Re: Duplicating users and their objects

From: Robert Cordingley <cord_at_zoom.com>
Date: 1996/09/29
Message-ID: <324eeb26.3794592_at_news.zoom.com>#1/1

On Fri, 20 Sep 1996 17:07:04 GMT, nospams_at_rossinc.com (David Moore) wrote:

>Is there a way to tell imp which tablespaces I wish to use? I'm
>running these test on VMS and various flavors of Unix, so hopefully
>there's a portable way to do this. :-/

It's drop-dead simple. When you want to import to a different tablespace, you just don't give the user quota on the tablespace where the tables originated. When Oracle can't create the table there, it creates it in the user's default tablespace. So, if you set the user's default tablespace and make sure he ONLY has quotas on it, then all the created objects will

end up there.  There's no need to hack any files or do anything
undocumented.  If you read the manual thoroughly, this technique is
documented....albeit in a place that makes no sense at all.  I'm not sure

where in the book it's located. Also, I think you have to use ignore=y so it won't exit when it can't put them in their source tablespace.

                                Robert

PS: Make sure the user in question also has no write access to any tables by the same name created for a different user. Received on Sun Sep 29 1996 - 00:00:00 CEST