有个测试数据库的sys密码中有一个@字符,如果用sqlplus sys/**@**登录显然会报错,
这时候需要转义一下,比如:
SQL> create user justin identified by "12@3";
User created.
[oracle@yihaodian-wh ~]$ sqlplus justin/\"12@3\"
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 26 14:42:11 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL>