Re: rename users

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 03 Nov 1998 14:14:35 GMT
Message-ID: <363f0fb6.3695083@192.86.155.100>

A copy of this was sent to "Jan Birk" <jbirk_at_relief.dk> (if that email address didn't require changing) On Tue, 3 Nov 1998 07:58:43 +0100, you wrote:

>Hi
>
>If I create a new user I have to export the old user and then
>doing:fromuser=old_user touser=new_user. If I have to change over 500 users,
>this will take tooooooo long.
>
>The esy thing to do, is renaming a username but how?
>

you cannot rename a schema/user in Oracle.

>
>That why
>
>
>Thanks
>
>Jan Birk
>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Nov 03 1998 - 08:14:35 CST