no problem ... thanks for the effort ... but fyi ... if u enclose the =
pwd in
" " then it will accept it with a number e.g. "22abc" ... and then =
when you
log on to sql+ u do it in the normal fashion
connect user1/22abc @whatever
happy new year!
thank you ...
nechama glasrot
561-981-0635
nglasrot_at_edata.com
-----Original Message-----
From: Ron Rogers
Sent: Thursday, December 28, 2000 3:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: changing password
nechama,
I did some checking after my first response. I could not find it in =
any of
my books BUT the password can not begin with a number or special =
characters.
Sorry to have sent you on a goose chase about the profiles.
ROR m=AA=BF=AAm
Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV 12/28/00 03:05PM >>>
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-----
Sent: Thursday, December 28, 2000 1:10 PM
To: Multiple recipients of list ORACLE-L
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_at_edata.com=20
--=20
Please see the official ORACLE-L FAQ:
http://www.orafaq.com=20--=20
Author: Glasrot, Nechama
INET: nglasrot_at_edata.com=20
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_at_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).
--=20
Please see the official ORACLE-L FAQ:
http://www.orafaq.com=20--=20
Author: Norwood Bradly A
INET: Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV=20
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_at_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).
--=20
Please see the official ORACLE-L FAQ:
http://www.orafaq.com--=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org
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_at_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
