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