EXP-00091: Exporting questionable statistics.

来源：互联网发布：数据库概论第五版王珊编辑：程序博客网时间：2024/05/22 03:12

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->