Oracle用户密码含有特殊字符应当如何处理
来源:互联网 发布:程序员没有女朋友组图 编辑:程序博客网 时间:2024/06/05 19:59
但是在有特殊符号时,修改密码或着导入导出数据时会遇到麻烦,下文便是对该情况下的解释说明:
本文以特殊符号“/”作为例子
一、Linux环境,数据库为Oracle10g
1、修改密码
[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
此处使用""" """来处理用户密码
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语句中含有特殊字符的处理方式
- mac 10.9 usb安装win7的方法
- C# Winform 中webBrowser显示html内容时禁止错误提示的方法
- hwc_overlay
- TI wiki sd卡启动分区
- 海量影像快速发布(二)image service Definition
- Oracle用户密码含有特殊字符应当如何处理
- 使用 Flash 描述复杂的社交网络
- 关于android:screenOrientation="portrait"
- javascript常用小脚本 --完善ing
- 字符杂项设备(miscdevice)
- BP神经网络java实现,按照算法步骤也参考网上相关资源写的,若君有高见,非常欢迎指教
- HBase Java简单示例
- 关于oracle密码特殊字符在sqlplus、imp、exp里的使用
- 基于In-System Memory Content Editor的LCD实时显示字符更改