Issue the following SQL command:
ALTER USER <username> IDENTIFIED BY <new_password>;
From Oracle8 you can just type "password" from SQL*Plus, or if you
need to change another user's password, type "password user_name".
Look at this example:
SQL> password
Changing password for SCOTT
Old password:
New password:
Retype new password: