Home Email RSS Feed

Rename Oracle database username

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

If you've enjoyed this post, you might want to subscribe my RSS feed or email alerts for free updates. Thanks for visiting and come back again.

No, this is not available till now in Oracle & been noted down as a enhancement request.

Still here is a workaround way of doing that:

  1. Do a user-level export of user A
  2. create new user B
  3. import system/manager from user=A to user=B
  4. drop user A

Tags: ,

Leave a Comment