oracle修改用户名

一、需求

将test用户名修改为test1

二、步骤

select user#,name from user$ where name=‘TEST‘;

update user$ set name =‘TEST1‘ where user#=159;

commit;

alter system checkpoint;

alter system flush shared_pool;

alter user test1 identified by test1;