oracle 表名加 符号,oracle用户口令中带@符号问题

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

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

~$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 "";

User created.

SQL> grant dba to abs_test;

Grant succeeded.

本地连接使用双引号扩住本地就可以登陆

SQL>  conn abs_test/""

Connected.

SQL>

SQL> create user an identified by an ;

User created.

SQL> grant dba to an;

Grant succeeded.

远程连接

普通口令用户

C:\Documents and Settings\Administrator>sqlplus

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/"

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:

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

不能这么使用