oracle用户口令中带@符号问题

==================

oracle@localhost ~$sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 28 17:46:46 2010
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

创建特殊符号口令用户
SQL>  create user abs_test identified by "abc@dd";
User created.

SQL> grant dba to abs_test;
Grant succeeded.

本地连接使用双引号扩住本地就可以登陆
SQL>  conn abs_test/"abc@dd"
Connected.
SQL>

SQL> create user an identified by an ; 
User created.

SQL> grant dba to an;
Grant succeeded.

远程连接
普通口令用户
C:\Documents and Settings\Administrator>sqlplus an/an@197
SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 12月 28 18:01:31 2010
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

带特殊字符口令用户
C:\Documents and Settings\Administrator>sqlplus abs_test/"abc@dd"@197
SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 12月 28 18:01:35 2010
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

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

Enter user-name:

结论：虽然本地连接可以，但远程连接还是连不上，有限制的。
   不能这么使用