Message-Id: <10724.125406@fatcity.com> From: Norwood Bradly A Date: Thu, 28 Dec 2000 15:00:53 -0500 Subject: RE: changing password Perhaps, OEM or sqlplus.......... Note: Oracle recommends that you do not change passwords using the ALTER USER statement because it does not fully support the password verification function. Instead, you should use Oracle-provided tools such as SQL*Plus or Enterprise Manager to change passwords -----Original Message----- From: Glasrot, Nechama [mailto:nglasrot@edata.com] Sent: Thursday, December 28, 2000 1:10 PM To: Multiple recipients of list ORACLE-L Subject: changing password i have a user named abc ... he had a password of 22xyz ... i had to temporarily change the password to abc_temp ... i tried to change the password back to 22xyz ... and get the following error ... Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SQL> alter user abc identified by 22xyz_p; alter user abc identified by 22xyz_p * ERROR at line 1: ORA-00988: missing or invalid password(s) pls help ... tia thank you ... nechama glasrot 561-981-0635 nglasrot@edata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: nglasrot@edata.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).