We don’t have a single command in Oracle by which we can alter the name of a user. But, there is a workaround which serve the purpose.
Say, we have to rename user A to B.
- Take an export of user A.
- Create the user B.
- Import the dump file taken in step 1 to user B .
- Drop the user A.
Article by : Anju