/*

update user$ set name='OLD' where name='NEW';

alter system checkpoint; alter system flush shared_pool; alter user zz identified by zz;

*/

 

环境：solaris9 ORACLE 10.2.0.2

SQL> select name,user#,password from user$;

USER1                                  31 BBE7786A584F9103

USER2                                  32 1718E5DBB8F89784

比如要把USER1 改为USER2

SQL> drop user user2 cascade;

User dropped.

SQL> update user$ set name='USER2' where user#=31;

1 row updated.

SQL> commit;

Commit complete.

SQL> alter system checkpoint;

System altered.

SQL> alter system flush shared_pool;

System altered.

SQL> alter user user2 identified by values '1718E5DBB8F89784';

User altered.

 

SQL> conn user2/user2

Connected. SQL> select * from tab;

TNAME           TABTYPE    CLUSTERID

----------------- --------------   ---------- T1                  TABLE

SQL> select count(*) from t1;

COUNT(*)

----------       4148

 

完毕。