Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: duplicating schema
Hi,
use the fromuser touser options on the import.
IMP system/manager file=<export name> fromuser=<original user> touser=<new user>
Trevor
Franz Mueller wrote:
> Hi,
> I would like to know if there is a way to duplicate a user. What I
> want to do is the following:
> i have exported (exp80) the production db from a customer and I want
> to restore it twice on our local server. The problem is that it seems
> to be only possible to reimport it to the original user name. Is there
> a way to copy it to another user name?
>
> Thanks
> Franz
Received on Thu Aug 05 1999 - 04:10:28 CDT