Database tables have been built in the project, but you suddenly need to change the user name.
Through the Plsql Client interface form is not modified. So directly change the user name in the System user$ table.
Query the user name you want to change
Sql> Select User#,name,password from user$ where name = ' tickets ';
user# NAME PASSWORD---------------------------------------------------------------------- Tickets 21EDA78F89D6FACD
change user name
sql> Update user$ set name= ' Tickets_bak ' where user#=78;
1 row updated.
Sql> commit;
Commit complete.
After the user name changes, the data dictionary information needs to be clearly cached.
Sql> alter system checkpoint; ----Forcing the data file to be written
System altered.
Sql> alter system flush Shared_pool; ----Clearly cache data dictionary information, forcing Oracle to read the actual data (that is, the changed data)
System altered.
and change the user login password.
sql> alter user Tickets_bak identified by ' Aaaab ';
User altered.
Oracle change user Name