ORACLE change user Name

Oracle's user passwords have been modified frequently, but user names are rarely modified.

Before you can create only one user 1, then import user 2 data to User 1, and then delete by user 1, this is very cumbersome and time-consuming, and today we have sorted out how to modify the Oracle user name:

1, enter with SYSDBA role account, and then query which users:

SELECT * from user$

2. Find the user who needs to be modified (the user# field is unique)

SELECT * from user$ WHERE user#=

3. Modify the user name you want to change

UPDATE user$ SET name= ' new user name ' WHERE user#=;
COMMIT;

4. Forced refresh

ALTER SYSTEM CHECKPOINT;
ALTER SYSTEM FLUSH Shared_pool;

5, the new user name corresponding to the password modified (otherwise unable to login)

ALTER User new username identified by ' password ';

6, at this point, done, ok!



ORACLE change user Name