EXP-00091: Exporting questionable statistics.

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 666 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#character #table #constraints #import #database #buffer

Oracle 同时被 2 个专栏收录

523 篇文章

订阅专栏

Oracle EBS

416 篇文章

订阅专栏

本文记录了在使用Oracle 10g进行数据导出时遇到的问题及解决过程。主要问题为导出过程中出现的可疑统计数据警告，通过设置NLS_LANG环境变量解决了字符集导致的问题，成功完成了指定表格的数据导出。

ora10glinux-> exp userid=***/***@orcl buffer=10240000 file=AA.dmp tables=(BANKRUNDATEBACKUP,IMPORT_TARGETEDLIST,TEST,TEST1,TEST10,TEST2,TEST3,TEST4,TEST5,TEST6,TEST7,TEST8,TESTDMP,BANKRUNDATE2,BANKRUNDATE,DUPLICATETAB,BANK) indexes=y rows=y consistent=y constraints=y

Export: Release 10.2.0.1.0 - Production on Thu Oct 15 11:28:29 2009

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 AL32UTF8 character set (possible charset conversion)

...

解决办法：

ora10glinux-> echo $NLS_LANG

ora10glinux->

SQL> SELECT USERENV('LANGUAGE') "Language" FROM DUAL;

Language
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

SQL> select * from props$ where name in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
COMMENT$
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
Language

NLS_TERRITORY
AMERICA
Territory

NLS_CHARACTERSET
AL32UTF8
Character set

NLS_NCHAR_CHARACTERSET
AL16UTF16

SQL>

ora10glinux->
ora10glinux-> export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ora10glinux-> exp userid=***/***@orcl buffer=10240000 file=AA.dmp tables=(BANKRUNDATEBACKUP,IMPORT_TARGETEDLIST,TEST,TEST1,TEST10,TEST2,TEST3,TEST4,TEST5,TEST6,TEST7,TEST8,TESTDMP,BANKRUNDATE2,BANKRUNDATE,DUPLICATETAB,BANK) indexes=y rows=y consistent=y constraints=y

Export: Release 10.2.0.1.0 - Production on Thu Oct 15 11:31:07 2009

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 AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table              BANKRUNDATEBACKUP        505 rows exported
. . exporting table            IMPORT_TARGETEDLIST       4178 rows exported
. . exporting table                           TEST    2606773 rows exported
. . exporting table                          TEST1      65824 rows exported
. . exporting table                         TEST10    5848064 rows exported
. . exporting table                          TEST2     182752 rows exported
. . exporting table                          TEST3      65824 rows exported
. . exporting table                          TEST4      45688 rows exported
. . exporting table                          TEST5      65824 rows exported
. . exporting table                          TEST6      45688 rows exported
. . exporting table                          TEST7      65824 rows exported
. . exporting table                          TEST8    5848064 rows exported
. . exporting table                        TESTDMP         10 rows exported
. . exporting table                   BANKRUNDATE2        505 rows exported
. . exporting table                    BANKRUNDATE         29 rows exported
. . exporting table                   DUPLICATETAB          6 rows exported
. . exporting table                           BANK         29 rows exported
Export terminated successfully without warnings.
ora10glinux->