Some users asked this question: How do I escape the @ symbol in the password during the export operation?
Because the default Oracle will parse the strings after the @ symbol as the service name, it will not work without processing.
Some enterprises Add the @ symbol to their passwords because of security rules.
Assume that the user password is as follows:
SQL> alter user eygle identified by "eygle @ com ";
User altered.
If you export data by default, the following error occurs:
[Oracle @ jumper oracle] $ exp eygle/eygle @ com file = eygle. dmp tables = test
Export: Release 9.2.0.4.0-Production on Fri Jan 4 11:17:48 2008
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS: cocould not resolve service name
EXP-00000: Export terminated unsuccessfully
Escape:
[Oracle @ jumper oracle] $ exp eygle/\ "eygle @ com \" file = eygle. dmp tables = test
Export: Release 9.2.0.4.0-Production on Fri Jan 4 11:12:10 2008
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0-Production
With the Partitioning option
JServer Release 9.2.0.4.0-Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path...
.. Exporting table TEST 4136 rows exported
-The End-