reset password with value

This methods is used to clone user with the same password or reset user to same password to clear account expired status.

select dbms_metadata.get_ddl('USER','TEST') from dual;

CREATE USER "TEST" IDENTIFIED BY VALUES 'S:C0ACFA8BB332DAA8ACF469B7C9F2AB07623B3C5358DB1ABCE05C1FCE057E;BDCFAC041379F0D9'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"
quota unlimited on users;
grant resource, connect, test_profile to test;

alter user coskan identified by  VALUES 'S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA;26EB15F771A78542';

select password,spare4 from user$ where name='U';
alter system set sec_case_sensitive_logon=true;

S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA -- for sensitive
26EB15F771A78542 -- for non-sensitive

if set up only non-sensitive, sec_case_sensitive_logon=true will not work.