Re: Alter user identified by with special chars

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 04 Mar 2004 22:15:03 +0100
Message-ID: <027f40p9pe6tla3t1brgqmhrb84f6oelh9@4ax.com>

On 4 Mar 2004 06:40:36 -0800, steven.fox_at_dfas.mil (Steven Fox) wrote:

>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????

double quote the password

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Mar 04 2004 - 15:15:03 CST