Today through EXP Migration Oracle data, because the password contains a lot of special characters, for a long time, did not succeed,
After the hair on the internet to find ways.
1 Exp Usage
Under Linux (password with a pair of double quotes, the whole userid is enclosed in single quotes)
Exp ' skytf/'? '}:q*h ' @skytf ' <[email protected]#<>? '}:q*h ' @skytf ' direct=y buffer=52428800 feedback=10000 Statistics=none
File=skytf.dmp Log=exp_skytf.log
Under Windows (three double quotes before and after passwords):
Exp skytf/"" # $ADF '%6^dfom "" "@skytf buffer=52428800 file=skytf.dmp Log=exp_skytf.log
2 here by the way record the use of the exp Query parameter.
Linux:exp Scott/tiger tables=emp query=\ "where job=\ ' salesman\ ' and sal\<1600\"
Windows exp>exp userid=tkyte/tkyte tables=t query= "" "where object_id < 5000" "
In Windows, you need to use three double quotes at both ends of the where statement
3 How to use the user when connecting
19:13:20 [email protected]> ALTER user SKYTF identified by "# $ADF '%6^dfom ';
The user has changed.
19:14:29 [email protected]> Conn skytf/"# $adf '%6^dfom ' @skytf
is connected.
Source: http://francs3.blog.163.com/blog/static/4057672720109871751980/
Use of Exp,imp when the Oracle password contains special characters