alter user username identified by NEWpassword password expire;
When user username login SQL asked to change passwordalter user username identified by NEWpassword;
From user
SQL>password
Old password:
New password:
Retype password:
Password changed
SQL>
Old password:
New password:
Retype password:
Password changed
SQL>