方法一:
1.用SYSDBA身份进入数据库
2.然后查询到要更改的用户信息:
select user#,name from user$ where name='username';
3、更改用户名并提交:
update user$ set name ='new_username' where user#=159; --user#为上一步查出的编号
commit;
4、强制刷新:
alter system checkpoint;
alter system flush shared_pool;
5、更新用户的密码:
alter user new_username identified by new_username;
方法二:
alter system set "_enable_rename_user"=true scope=spfile;
shutdown immediate;
startup restrict force;
alter user test rename to test1 identified by test1;
alter system disable restricted session;
conn test1/test1;
conn / as sysdba
alter system reset "_enable_rename_user";
shutdown immediate;
startup;