up vote 2 down vote favorite
share [g+] share [fb]

I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table? I use oracle 9.

link|improve this question
feedback

migrated from stackoverflow.com Mar 11 '11 at 2:04

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 3 down vote

In Oracle, as of version 11.2, you can't rename a schema (=user). See this discussion on AskTom for a workaround: you would export the user, reimport with the good name (using FROMUSER and TOUSER). All references (if any) in pl/sql code will have to be updated manually. Grants and public synonyms will have to be recreated separately.

link|improve this answer
oops, my fault. thank you for correcting me. – Benoit Mar 8 '11 at 12:41
@benoit: I was really curious to see if it's possible to rename a schema, but it looked too easy :) – Vincent Mar 8 '11 at 12:52
If you think about it, it would be problematic since it would change the how every object in the schema is referenced. For one thing it would have to modify code making it no longer in sync with your source repository. – JOTN Mar 11 '11 at 23:36
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.