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


Related posts:

  1. Oracle Database Performance Tuning – How to Export/Import Schema Statistics?
  2. How To Move OR Rename An Oracle Datafile?
  3. Can We Read Export Dump File Without Actually Importing It ?
  4. Not Able To Truncate Table – Why? What to do then?
  5. Flashback Table in Oracle Database – Query Recyclebin