关闭

exp导出EXP-00091: Exporting questionable statistics.

710人阅读 评论(0) 收藏 举报
分类:
导出时报:

EXP-00091: Exporting questionable statistics.

解决:这是字符集问题:
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

设置:

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

然后再执行导出:
[RHEL3]:[/templv/oracle10]$ exp dmp/dmp file=m_exec.dmp tables=m_exec
Export: Release 10.2.0.3.0 - Production on Wed Dec 4 10:33:50 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and UTF8 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table M_EXEC 88 rows exported
Export terminated successfully without warnings.
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:277214次
    • 积分:3676
    • 等级:
    • 排名:第8812名
    • 原创:111篇
    • 转载:31篇
    • 译文:1篇
    • 评论:11条
    博客专栏