当前位置: DBARoad > 备份恢复 > 文章正文

在导出一张小表时，报了个：

EXP-00091: Exporting questionable statistics.

原来是没有设置环境变量NLS_LANG的原因。
由于是小表，便直接执行了：

[/app/oracle]$ exp perfstat/perf1206stat@DB1 tables=CTZJ_STAT_BC_BAK file=CTZJ_STAT_BC_BAK.dmp log= CTZJ_STAT_BC_BAK_export.log

Export: Release 9.2.0.5.0 - Production on Mon Nov 10 09:02:10 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)

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

查询数据库字符集：

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

USERENV(’LANGUAGE’)
—————————————————-
AMERICAN_AMERICA.UTF8

设置环境变量NLS_LANG后，未再报错：

[/app/oracle]$ echo $NLS_LANG
ksh: NLS_LANG: parameter not set

[/app/oracle]$ cat exp.sh
export NLS_LANG=AMERICAN_AMERICA.UTF8
exp perfstat/perf1206stat@DB1 tables=CTZJ_STAT_BC_BAK file=CTZJ_STAT_BC_BAK.dmp log= CTZJ_STAT_BC_BAK_export.log

[/app/oracle]$ ./exp.sh

Export: Release 9.2.0.5.0 - Production on Mon Nov 10 09:04:29 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path …
. . exporting table CTZJ_STAT_BC_BAK 134164 rows exported
Export terminated successfully without warnings.

— The End —