Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 2 down vote favorite

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.

share|improve this question

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

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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