Shulou(Shulou.com)06/01 Report--

I. demand

Change the test user name to test1

II. Steps

Method 1: for all versions

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

Method 2: for oracle versions later than 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.