The Oracle password contains special characters, such as "@". It is written in imp and exp.

Source: Internet
Author: User
The Oracle password contains special characters, such as rdquo; @ ldquo;, which are written in imp and exp.

The Oracle password contains special characters, such as rdquo; @ ldquo;, which are written in imp and exp.

The Oracle password contains special characters, such as "@". It is written in imp and exp.

Today in Oracle data export, because the user name password is a special character, so encountered the error code: "EXP-00056: encountered ORACLE error 12154", online search for the reason, the quotation marks must be used for expansion, but the operating system is different in different ways:

Windows OS: exp username/"password" @ devdb -- password for three double quotes

Linux/unix OS: exp "username/" password "@ devdb" -- 1 double quotation mark password extension, 1 single quotation mark extension all

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.