Code:
SELECT password
FROM dba_users
WHERE user_name = 'xxx';

ALTER USER yyy IDENTIFIED BY VALUES 'password_from above query';
HTH