ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP-00091

EXP-00091

原创 Linux操作系统 作者:fei890910 时间:2013-11-17 17:32:12 0 删除 编辑
到处一张表的时候报错        
[oracle@node1 ~]$ exp scott/oracle tables=emp5 file=/home/oracle/emp5.dbf
Export: Release 11.2.0.1.0 - Production on Sun Nov 17 16:59:32 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           EMP5         14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

可能是字符的问题 
查看数据库的字符                            
SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';   
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK
在环境变量里添加下面一行                             
[oracle@node1 ~]$ vi .bash_profile
export NLS_LANG=american_america.ZHS16GBK
[oracle@node1 ~]$ source .bash_profile

再次到处表,成功导出                      
[oracle@node1 ~]$ exp scott/oracle tables=emp5 file=/home/oracle/emp5.dbf
Export: Release 11.2.0.1.0 - Production on Sun Nov 17 17:20:45 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table                           EMP5         14 rows exported
Export terminated successfully without warnings.



来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29108064/viewspace-776783/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-03113
下一篇: IMP-00033
请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    122
  • 访问量
    811223