Oracle 10G - how to export password?

Question

Oracle

Need to transfer password from one server to another (oracle 10G). On the old server, I received the password in encrypted form with the command:

select password from DBA_USERS where USERNAME='USER';

After that on the new server I enter:
alter user USER identified by values 'ЗНАЧЕНИЕ';
The password field of the DBA_USERS table and in USER$ on the new server is changed to the value from the old server. But it is not possible to log in after alter user - the password is not suitable.
What did I do wrong in this case and how to transfer the encrypted password correctly?

Answer 1

Try like this

Answer 2

Weird. What is the error when authorizing on a new server? Roles transferred? CONNECT, CREATE SESSION, is that all? Account not LOCKED?
As an option, don't bother and do ALTER USER...IDENTIFIED BY "password"