Wednesday, May 24, 2006

w00t: Rename user

Why there is no command for renaming any user schema in Oracle? I wish they give that option ASAP. It would have saved so much of my time today!

3 comments:

Alex Schroeder said...

I think if you have the appropriate secret Oracle powers, you can just update some of the tables in the data dictionary. V$ here I come!!

neurohavoc said...

maybe they are sadists and want u to wince every time u see the word "apps" under owner.

VKM said...

Not quite the anwer..
but have you seen this?

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:30020192108317