Re: Renaming schemas directly

I'm not going to repeat EVIL as every has already done (just going to think it very strongly) but in this particular case you failed the second time to reset the password, and password encryption depends on the user name (it's easy to check without doing anything dirty: just create two users TEST1 and TEST2, give them the same password, and check encrypted values - they are different).

HTH Stéphane Faroult

Bellows, Bambi (Comsys) wrote:
>
> Hey there Team!
>
> It would sure be swell if Oracle gave us some means to rename schemas,
> but, they don’t. I’m in 10g, and going behind the scenes, I can rename
> a schema, once, but I can’t seem to rename it back again. Here’s the
> deal-i-o…
>

--
http://www.freelists.org/webpage/oracle-l