Re: Alter user identified by with special chars

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 4 Mar 2004 11:26:16 -0800
Message-ID: <4b5394b2.0403041126.47295621@posting.google.com>

steven.fox_at_dfas.mil (Steven Fox) wrote in message news:<256a75fa.0403040640.78bb13d4_at_posting.google.com>...
> I have changed a password in OEM to abcde1!1 without a problem....
> I have been able to log into sql*plus with this password...
> BUT when I try to do:
>
> 1* alter user foxtest identified by foxtest1!1
> SQL> /
> alter user foxtest identified by foxtest1!1
> *
> ERROR at line 1:
> ORA-00922: missing or invalid option
>
> I get an error......
> Any idea????

have you tried quoting the password? Received on Thu Mar 04 2004 - 13:26:16 CST