exp 转义_如何转义口令中的特殊符号（如@）

如何转义口令中的特殊符号(如@)

SQL> alter user eygle identified by "eygle@com";

User altered.

如果缺省导出会出现如下错误：

[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, 2002, Oracle Corporation.  All rights reserved.

EXP-00056: ORACLE error 12154 encountered

ORA-12154: TNS:could not resolve service name

EXP-00000: Export terminated unsuccessfully

通过转义，可以成功导出：

[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, 2002, 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-

By eygle on 2008-01-04 11:30 |

Comments (6) |

FAQ | 1728 |

6 Comments

学习了 我很讨厌密码里有这个@ 字符

就是，为啥密码里要写个@符号，那sqlplus登陆的时候也不方便啊

在windows下应该这样写：

exp scott/"""tiger@xx"""

即：密码外面包括三对双引号