简单修改Oracle用户名

假设原用户名为A，现在要修改用户名为B。

SQL> alter system checkpoint;

System altered.

SQL> select username from dba_users where username='A';

USERNAME
------------------------------
A

SQL> update user$ set name='B' where name='A';

1 row updated.

SQL> alter system checkpoint;

System altered.

SQL> alter system flush shared_pool;

System altered.

SQL>  alter user B identified by B;

User altered.

SQL> commit;

Commit complete.

SQL> select username from dba_users where username='A';

no rows selected

SQL>  select username from dba_users where username='B';

USERNAME
------------------------------
B

SQL> conn B/B
Connected.