How to change the schema or user name in Oracle

Developers have a requirement to move all objects in a schema to another shema. After thinking about it, simply change the schema name? In this way, you do not need to move

Developers have a requirement to move all objects in a schema to another shema. After thinking about it, simply change the schema name? In this way, you do not need to move

Developers have a requirement to move all objects in a schema to another shema. After thinking about it, simply change the schema name? In this way, you do not need to move the data. You are prepared to directly change the data using DDL statements:

This statement was not found at all. After I checked it online, I found that Oracle itself did not provide this function, but there was a data dictionary table: user $, all users in this table can directly update the table and try to change it. It is quite useful and the implementation is as follows: