如果非要把密码修改为以数字开头或有特殊字符的密码,可以使用如下方法:
SQL> alter user test identified by "123abc";
User altered.
此处应该使用" "
下面的操作在密码中使用“/”
SQL> alter user test identified by "123/abc";
User altered.
SQL>
[oracle@jfdb oracle]$ exp test/123/abc file=mytest.dmp buffer=65536
Export: Release 10.2.0.4.0 - Production on Wed Oct 19 14:32:10 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00004: invalid username or password
Username:
此处应该进行转义使用 " "处理密码,使用 ' '处理用户名和密码
[oracle@olivenan oracle]$ exp 'test/"123/abc"' file=test.dmp buffer=65536
Export: Release 10.2.0.4.0 - Production on Wed Oct 19 14:32:10 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/715865/viewspace-682777/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/715865/viewspace-682777/