Oracle用户密码含有特殊字符应当如何处理
来源:互联网 发布:期货程序化模型源码 编辑:程序博客网 时间:2024/06/03 17:19
[oracle@olivenan oracle]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 17 14:33:32 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter user test identified by aa/aa;
alter user test identified by aa/aa
*
ERROR at line 1:
ORA-00922: missing or invalid option
此处应该使用""
SQL> alter user test identified by "aa/aa";
User altered.
SQL>
[oracle@olivenan oracle]$ exp test/aa/aa file=test.dmp buffer=65536
Export: Release 10.2.0.1.0 - Production on Wed May 17 14:32:10 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00004: invalid username or password
Username:
此处应该进行转义使用 " "处理密码,使用 ' '处理用户名和密码
[oracle@olivenan oracle]$ exp 'test/"aa/aa"' file=test.dmp buffer=65536
Export: Release 10.2.0.1.0 - Production on Wed May 17 14:32:52 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
...............
导出成功,此处省略
二、Windows Xp下,数据库为Oracle9i
C:\Documents and Settings\w>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 17 14:56:34 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/olivenan as sysdba
Connected.
SQL> alter user test identified by aa/aa;
alter user test identified by aa/aa
*
ERROR at line 1:
ORA-00922: missing or invalid option
此处使用""
SQL> alter user test identified by "aa/aa";
User altered.
SQL>
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\w>exp test/aa/aa file=aa.dmp buffer=65536
Export: Release 9.2.0.1.0 - Production on Wed May 17 14:58:50 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
EXP-00004: invalid username or password
Username:
Password:
EXP-00056: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon denied
Username: ^Z^Z
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully
此处使用""" """来处理用户密码 是6个双引号
C:\Documents and Settings\w>exp test/"""aa/aa""" file=aa.dmp buffer=65536
Export: Release 9.2.0.1.0 - Production on Wed May 17 14:59:10 2006
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
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user test
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user test
About to export test's objects ...
. exporting database links
. exporting sequence numbers
........
- Oracle用户密码含有特殊字符应当如何处理
- Oracle用户密码含有特殊字符应当如何处理
- [转载]如何处理含有特殊字符的数据库查询语句
- oracle创建用户密码带特殊字符
- json中含有特殊字符串如何处理
- oracle & 和 ' 特殊字符处理
- oracle 特殊字符的处理
- oracle & 和 ' 特殊字符处理
- oracle特殊字符(‘&’,‘‘’)处理
- Oracle sql特殊字符处理
- Oracle 用户密码含特殊字符时的登陆问题(转)
- 【方法】Oracle用户密码含特殊字符时的登陆问题
- 处理生成文件名称时含有的特殊字符
- SQL语句处理含有特殊字符的表名
- GET请求中参数含有某些特殊字符的处理
- window.showModalDialog 参数传递中含有特殊字符的处理
- 链接中含有+号特殊字符处理,不能传到后台
- sql语句中含有特殊字符的处理方式
- 字幕编辑软件Aegisub-2.1.9-portable绿色版
- rman备份实例
- IBATIS batch用法探究
- sql 2005如何使用被禁止的xp_cmdshell
- Android: 从 Android Source Tree 中编译SDK的正确方法
- Oracle用户密码含有特殊字符应当如何处理
- 如何从PreferenceActivity删除一个Preference
- 实例解析linux内核I2C体系结构(2)
- C语言中的位运算
- windows、linux下的共享目录如何挂到LINUX下
- ubunbu 12.04 安装sun JDK 去除OpenSDK 的默认配置
- 怎样获得oracle当前数据库的SCN值
- 技术网站
- 理解 LVM (Logical Volume Manager)