oracle 11g 修改用户名

来源：互联网发布：帝国cms阿里云oss插件编辑：程序博客网时间：2024/05/21 11:06

创建test用户：
sys@DEVDB>create user test identified by test;

User created.

查找test信息：

sys@DEVDB>select user#,name,password from user$ where name ='TEST';

USER# NAME PASSWORD
-------------------- ------------------------------ ------------------------------
474 TEST 7A0F2B316C212D67

修改用户名：

sys@DEVDB>update user$ set name='TEST_BAK' where user#=474;

1 row updated.

sys@DEVDB>commit;

Commit complete.

sys@DEVDB>select user#,name,password from user$ where name ='TEST';

no rows selected

sys@DEVDB>select user#,name,password from user$ where name ='TEST_BAK';

USER# NAME PASSWORD
-------------------- ------------------------------ ------------------------------
474 TEST_BAK 7A0F2B316C212D67

创建相同用户：

sys@DEVDB>create user test identified by test;
create user test identified by test
*
ERROR at line 1:
ORA-01920: user name 'TEST' conflicts with another user or role name

强制oracle将数据写入磁盘：
sys@DEVDB>alter system checkpoint;

System altered.

清空内存，使数据库读取磁盘数据：

sys@DEVDB>alter system flush shared_pool;

System altered.

再次创建test用户：

sys@DEVDB>create user test identified by test;

User created.
成功。