How do I change my Oracle password using SQL*Plus?

To change your Oracle password using SQL*Plus:

1. From the Programs menu, select SQL Plus.
   
   
2. In the window that appears, enter your Oracle username and password in the appropriate spaces.
   
   
3. Next to "Host String", enter the Net Service name of the Oracle database (e.g., oed1, oed1.world, oed1.uits.indiana.edu).
   
   
4. You should now be in the SQL*Plus command line interface. To change your password, use the following command: password
5. When prompted, enter your old password. Enter your new password, and then retype your new password. If this is successful, SQL*Plus will tell you your password has been changed.

Passwords must be 6 to 30 characters and begin with an alphabetic character. They can contain only alphanumeric characters and the characters  _ ,  $ , and  # .

Although best practices for passwords call for the use of passphrases with spaces, such use can create a variety of problems for Oracle database account holders. A passphrase containing spaces could still work with Oracle, but it has to be used with more planning and precision, depending on the platform or the particular Oracle client software product being used. Unfortunately, passphrases containing spaces cannot be provided in a simple, consistent manner, as is the case with an Oracle password that does not contain spaces.

Comments/Questions/Corrections