oracle中数据库(user)重命名

-- 以sys用户登录
sqlplus / as sysdb

--创建用户并授权
create user user_name identified by pwd;
grant connect,resource to user_name;

--尝试修改user_name，报错：选项缺失或无效
alter user old_user rename to new_user identified by new_pwd;

--更改系统设置，scope=spfile还不知道什么意思
alter system set "_enable_rename_user"=true scope=spfile;

--以restrict mode重启oracle，可以看一下oracle的启动/关闭过程
shutdown immediate
startup restrict

--再次修改，提示：user is alterd
alter user old_user rename to new_user identified by new_pwd;