The Oracle password contains special characters, such as "@". It is 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