Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: duplicating schema

Re: duplicating schema

From: Trevor Pearce <trevor.pearce_at_onyx.net>
Date: Thu, 05 Aug 1999 10:10:28 +0100
Message-ID: <37A95504.A5E698E4@onyx.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US