暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

EXP导出报错EXP-00091处理记录

原创 Leo 2022-06-12
613

系统:oel 5.4

数据库:oracle 10.2.0.1

问题描述:在执行导出命令时报错EXP-00091,如下所示:

[oracle@leo ~]$ exp scott/tiger@orclsou file=/home/oracle/scott.dmp tables=emp_ogg,dept_ogg rows=y

Export: Release 10.2.0.1.0 - Production on Mon May 30 14:45:23 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses WE8ISO8859P1 character set (possible charset conversion)


About to export specified tables via Conventional Path ...

. . exporting table                        EMP_OGG         14 rows exported

. . exporting table                       DEPT_OGG          4 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

通常造成此异常为字符集原因,查数据库字符集

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.WE8ISO8859P1

查系统环境变量NLS_LANG

[oracle@leo ~]$ echo $NLS_LANG


[oracle@leo ~]$  

如上,系统未设置语言环境变量.

解决方案:

[oracle@leo ~]$ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

[oracle@leo ~]$ echo $NLS_LANG

AMERICAN_AMERICA.WE8ISO8859P1

再次执行exp,如下:

[oracle@leo ~]$ exp scott/tiger@orclsou file=/home/oracle/scott.dmp tables=emp_ogg,dept_ogg rows=y log=/home/oracle/exp.log

Export: Release 10.2.0.1.0 - Production on Mon May 30 14:52:49 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...

. . exporting table                        EMP_OGG         14 rows exported

. . exporting table                       DEPT_OGG          4 rows exported

Export terminated successfully without warnings.

结论:成功导出,无任何告警.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论