Re: How to change an oracle's user name

Steve Adams wrote:

> >> Does anyone know if it's possible to change the name of an oracle's
> >> user?
> >
> >no you can not. create a new user, export/import the contents of the old
> >user, drop old user.
>
> No, you can simply update sys.user$ directly, then bounce the
> instance.
>

A caveat here, those kinds of messing around with underlying tables are not supported by oracle and if you crahs your instance, be prepared to be doing a full restore. Some things are just not worth the chance.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta
That is also the place to find the FREE, drop column script
ICQ UIN:  2832230(&oracle, home).