Rename Oracle database username

No, this is not available till now in Oracle and has 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

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top