oracle怎样修改用户名,oracle 11g 修改用户名

创建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.

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. 成功。