如何才能实现Oracle测试库上更改用户名

conn / as sysdba
UPDATE USER$ SET NAME='A2B' WHERE NAME='HH';
ALTER SYSTEM CHECKPOINT;--强制写入数据文件
ALTER SYSTEM FLUSH SHARED_POOL;--清除缓存数据字典信息
alter user a2b identified by a;




SQL> conn hh/a
Connected.

SQL> SELECT COUNT(*) FROM USER_OBJECTS;

COUNT(*)
----------
952
SQL> conn / as sysdba
Connected.
SQL> show user
USER is "SYS"

SQL> UPDATE USER$ SET NAME='A2B' WHERE NAME='HH';

1 row updated.

SQL> commit;

Commit complete.

SQL> ALTER SYSTEM CHECKPOINT;

System altered.

SQL> ALTER SYSTEM FLUSH SHARED_POOL;

System altered.

SQL> alter user a2b identified by a;

User altered.

SQL> conn a2b/a
Connected.
SQL> SELECT COUNT(*) FROM USER_OBJECTS;

COUNT(*)
----------
952

SQL>