hello,
i use oracle10g and i forgot my user password
i remember there's a procedure (command line) to reassign the password...

someone may tell me how to?

thanks

PS: is this procedure for user "system" or "sys" too?

alter user <username> identified by <pswd>;
you need to have admin rights to do so/ connect with db.

use orapwd utility for sys pasword.

so, to reassign "sys" password i use:

orapwd file=pwddb.ora password="newpwd"

is it right?
i do specify user "sys" or not?

dont have any idea if you are on windows or unix plateform.

for windows, consider first stopping the service and than do so.
you might want to put files in the appropriate folder/directory. so give path too in the file name. on windows it would be like D:\Oracle\ora920\database or on unix it should be like $ORACLE_HOME/dbs
you dont need to use "quotes" for password