原来脚本运行很好,但是密码改成了带@的密码之后就不能运行了,怎么办?
@sqlplus username/abc@123456@TNSname
系统报不能解析
解决思路如下:
C:/>SQLPLUS "/ AS SYSDBA"
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 6 11:15:52 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> CREATE USER TTT IDENTIFIED BY "TT@TT";
User created.
SQL> GRANT CONNECT,PUBLIC TO TTT;
Grant succeeded.
SQL> CONNECT TTT/"TT@TT"@ORCL
Connected.
最主要是后便一句 把密码用双引号引起来。