How To Rename A User/Schema In Oracle?

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.

  1. Take an export of user A.
  2. Create the user B.
  3. Import the dump file taken in step 1 to user B .
  4. Drop the user A.

Article by : Anju