EXP－00091 Exporting questionable statistics解決的方法|Oracle Oracle备份与恢复 TTTBLOG

select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'

or

select * from v$nls_parameters  where parameter='NLS_CHARACTERSET';

SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

 

PARAMETER　　　　      VALUE

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

NLS_CHARACTERSET    ZHT16BIG5

WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5

LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5

oerr exp 91

00091, 00000, "Exporting questionable statistics."

// *Cause:  Export was able export statistics, but the statistics may not be

//          usuable. The statistics are questionable because one or more of

//          the following happened during export: a row error occurred, client

//          character set or NCHARSET does not match with the server, a query

//          clause was specified on export, only certain partitions or

//          subpartitions were exported, or a fatal error occurred while

//          processing a table.

// *Action: To export non-questionable statistics, change the client character

//          set or NCHARSET to match the server, export with no query clause,

//          export complete tables. If desired, import parameters can be

//          supplied so that only non-questionable statistics will be imported,

//          and all questionable statistics will be recalculated.

SQL> select * from v$nls_parameters  where parameter='NLS_CHARACTERSET';

 

PARAMETER

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

VALUE

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

NLS_CHARACTERSET

ZHS16GBK

 

--退出，在win下设置环境变量

C:>set NLS_LANG=AMERICAN_AMERICA.ZHS16BK

 

--开始导出数据

C:>exp endba/xxx@hs01 tables=enshpms file=e:enshpms.dmp

 

Export: Release 10.2.0.1.0 - Production on Mon Dec 27 18:46:19 2010

 

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

 

 

EXP-00056: ORACLE error 12705 encountered

ORA-12705: Cannot access NLS data files or invalid environment specified

Username:

Password:

 

EXP-00056: ORACLE error 12705 encountered

ORA-12705: Cannot access NLS data files or invalid environment specified

Username:

Password:

 

EXP-00056: ORACLE error 12705 encountered

ORA-12705: Cannot access NLS data files or invalid environment specified

EXP-00005: all allowable logon attempts failed

EXP-00000: Export terminated unsuccessfully

C:>exp endba/xxx@hs01 tables=enshpms file=e:enshpms.dmp

 

Export: Release 10.2.0.1.0 - Production on Mon Dec 27 19:01:11 2010

 

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

 

 

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

Production

With the Partitioning, OLAP and Data Mining options

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

server uses ZHS16GBK character set (possible charset conversion)

 

About to export specified tables via Conventional Path ...

. . exporting table                        ENSHPMS      20077 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

C:>SET NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

 

C:>exp endba/xxx@hs01 tables=enshpms file=e:enshpms_20101227.dmp

 

Export: Release 10.2.0.1.0 - Production on ╨╟╞┌╥╗ 12╘┬ 27 19:07:27 2010

 

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

 

 

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

Production

With the Partitioning, OLAP and Data Mining options

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

 

About to export specified tables via Conventional Path ...

. . exporting table                        ENSHPMS      20077 rows exported

Export terminated successfully without warnings.

 

C:>

C:>imp endba/xxx@hs01-60 file=d:enshpms_20101227.dmp

 

Import: Release 8.1.6.0.0 - Production on 星期一 12月 27 19:04:01 2010

 

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

 

 

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

 

IMP-00010: 不是有效的导出文件，标题检验失败

IMP-00000: 未成功终止导入

C:>exp endba/xxx@hs01 tables=enshpms file=d:enshpms.dmp

 

Export: Release 8.1.6.0.0 - Production on 星期一 12月 27 19:09:47 2010

 

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

 

 

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Produc

tion

With the Partitioning, OLAP and Data Mining options

已导出ZHS16GBK字符集和UTF8 NCHAR 字符集

 

即将导出指定的表通过常规路径 ...

. . 正在导出表                        ENSHPMS      20077 行被导出

 

C:>imp endba/xxx@hs01-60 file=d:enshpms.dmp

 

Import: Release 8.1.6.0.0 - Production on 星期一 12月 27 19:21:53 2010

 

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

 

 

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

 

经由常规路径导出由EXPORT:V08.01.06创建的文件

已经完成ZHS16GBK字符集和UTF8 NCHAR 字符集中的导入

. 正在将ENDBA的对象导入到 ENDBA

. . 正在导入表                       "ENSHPMS"      20077行被导入

IMP-00009: 导出文件异常结束

成功终止导入，但出现警告。