Use of Exp,imp when the Oracle password contains special characters

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.