一、需求
將test用戶名修改為test1
二、步驟
方法一：針對(duì)所有版本
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;
方法二：針對(duì) oracle 11.2.0.2之后版本
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;

成都創(chuàng)新互聯(lián)公司主營(yíng)宕昌網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,app軟件開發(fā)公司,宕昌h5成都微信小程序搭建,宕昌網(wǎng)站營(yíng)銷推廣歡迎宕昌等地區(qū)企業(yè)咨詢