ORACLE change username

Oracle has been constantly changing user password, but very few changes username.

Once only can create a user 1. The user 2 data is then imported into user 1. Then deleted by the user 1, this is cumbersome and time-consuming, today to sort out how to change the Oracle's username:

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

SELECT * from user$

2. Find the user who needs to be changed (the user# field is a unique identifier)

SELECT * from user$ WHERE user#=

3, changes need to change the username

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

4. Forced refresh

ALTER SYSTEM CHECKPOINT;
ALTER SYSTEM FLUSH Shared_pool;

5, then the new username corresponding to the password changes (otherwise unable to login)

ALTER USER new username identified by 'password';

6, to this point. Done. Ok!



ORACLE change username