Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I copy Oracle user accounts from 1 instance to another?
You can use import/export oracle utilites with the option fromuser / touser
Example :
exp user/pwd_at_sid1 compress=Y file=/ExpFiles/exp_user.dmp log=/oralog/exp_user.log
imp system/pwd_at_sid2 fromuser=user touser=user file=/ExpFiles/exp_user.dmp log=/oralog/imp_user.log
Greg
>
> Question: I have user accounts created in 1 instance that I would like to
> duplicate in another instance. I want to grab the user account, password,
> grants & roles specifically
>
> Does anyone have a solution?
>
> Stephanie
Received on Wed Oct 28 1998 - 00:00:00 CST