oracle-databaseplsqlschemaoracle11gr2

How to change schema name?

I have created a user:

CREATE USER gds_map
IDENTIFIED BY gds_map;

And now I need to change a name. I tried to update or find other way but have not found nothing yet.

I will be glad of any hint.

Solution

  • You can't (at least not in a supported or vaguely responsible way). You'd need to create a new user with the new username and drop the old user.