how modify username in oracle
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.
Related videos on Youtube
![Amir](https://i.stack.imgur.com/ylFnx.jpg?s=256&g=1)
Amir
I am a hardworking and motivated software engineer who has acquired extensive knowledge in the field through the study of software engineering at the PhD level. I have working experience in the information technology and financial industry in the insurance sector. I am looking for a new challenge on my career path to fulfil my experience in a different career path with new opportunities. Moreover, I am keen to learn new technologies and I am a victim of developaralysis...
Updated on September 17, 2022Comments
-
Amir almost 2 years
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.
-
Vincent over 13 years@benoit: I was really curious to see if it's possible to rename a schema, but it looked too easy :)
-
JOTN over 13 yearsIf 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.