Oracle Database Discussions

Hi Experts,

Can we create a user with password containing non-ASCII characters like "Ro'çá".

I was able to create a database instance by providing the password for sys as "Ro'çá". But now i am not able to login from command prompt using sqlplus or SQLPLUS Application. I am getting below error:

_________________________________________________________________________________
C:\Documents and Settings\xyz>sqlplus system/Ro'çá@test

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 4 12:17:33 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:

same in case i enclose the password in ""

_________________________________________________________________________________

C:\Documents and Settings\xyz>sqlplus system/"Ro'çá"@test

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 4 12:17:33 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:

same in case i enclose the password in ""

_________________________________________________________________________________

Also using create user i am not able to create user with password in non-ASCII characters but alter user works and changes the password to non-ASCII characters when enclosed in quotes.


I wanted to know whether the password can contain non-ASCII characters or not?

Thanks in advance for your help.