Typically, we set the password to be more complex when setting the Oracle password, which usually consists of an alphanumeric special symbol.
However, when you have special symbols, you may have trouble modifying your password or importing the exported data, which is explained in the following context:
This article takes the special symbol "/" as an example
One, Linux environment, database for oracle10g
1, modify the password
[Oracle@olivenan oracle]$ sqlplus '/as sysdba '
Sql*plus:release 10.2.0.1.0-production on Wed 17 14:33:32 2006
Copyright (c) 1982, +, 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
Here you should use the ""
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 17 14:32:10 2006
Copyright (c) 1982, +, Oracle. All rights reserved.
Exp-00004:invalid Username or password
Username:
You should escape using "process password, use '" to process user name and password
[Oracle@olivenan oracle]$ exp ' test/' AA/AA ' file=test.dmp buffer=65536
Export:release 10.2.0.1.0-production on Wed 17 14:32:52 2006
Copyright (c) 1982, +, 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
...............
Export successful, omitted here
Second, under Windows XP, the database is oracle9i
C:\Documents and Settings\w>sqlplus/nolog
Sql*plus:release 9.2.0.1.0-production on Wed 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
Here, use the
sql> alter user test identified by "AA/AA";
User altered.
Sql>
Microsoft Windows XP [version 5.1.2600]
(C) Copyright 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 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
Use "" "" "to process user passwords here
C:\Documents and Settings\w>exp test/"" "Aa/aa" "" File=aa.dmp buffer=65536
Export:release 9.2.0.1.0-production on Wed 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