EXP-00091: Exporting questionable statistics_MySQL教程

推荐：由于文件组 ‘DEFAULT’ 中的磁盘空间不足，无法为数据库 ‘TEMPDB’ 分配新页
今天接到一个朋友的问题，sql server报由于文件组 DEFAULT 中的磁盘空间不足，无法为数据库 TEMPDB 分配新页，按照错误提示应该是tempdb空间不足，让其查看tempdb对应数据库文件大小为不到4g，查看其对应文件为自增长，硬盘空间还有40g多点，那应该没有问题。后来她说

 　　一.出现EXP-00091错误

　　[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

　　> file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log

　　Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:02:37 2012

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

　　Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　Export done in US7ASCII character set and AL16UTF16 NCHAR character set

　　server uses ZHS16GBK character set (possible charset conversion)

　　About to export specified tables via Conventional Path ...

　　Current user changed to TESTXUCHAO

　　. . exporting table TAB_XN_PY_DICT 25433 rows exported

　　EXP-00091: Exporting questionable statistics.

　　EXP-00091: Exporting questionable statistics.

　　Export terminated successfully with warnings.

　　当环境变量和数据库的不一致，在导出统计信息时候，会报EXP-00091错误。

　　二.查看NLS相关参数

　　[oracle@localhost tmp]$ echo $NLS_LANG

　　AMERICAN

　　SQL> col value for a30

　　SQL> select parameter,value from nls_database_parameters

　　2 where parameter like '%CHARACTERSET%';

　　PARAMETER VALUE

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

　　NLS_CHARACTERSET ZHS16GBK

　　NLS_NCHAR_CHARACTERSET AL16UTF16

　　三.解决方法

　　1.设置NLS_LANG为NLS_CHARACTERSET

　　[oracle@localhost tmp]export NLS_LANG=american_america.ZHS16GBK

　　[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

　　> file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log

　　Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:10 2012

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

　　Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

　　About to export specified tables via Conventional Path ...

　　Current user changed to TESTXUCHAO

　　. . exporting table TAB_XN_PY_DICT 25433 rows exported

　　Export terminated successfully without warnings.

　　2.使用statistics=none

　　[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

　　> file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log statistics=none

　　Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:53 2012

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

　　Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　Export done in US7ASCII character set and AL16UTF16 NCHAR character set

　　server uses ZHS16GBK character set (possible charset conversion)

　　About to export specified tables via Conventional Path ...

　　Current user changed to TESTXUCHAO

　　. . exporting table TAB_XN_PY_DICT 25433 rows exported

　　Export terminated successfully without warnings.

分享：sqlserver多版本查看版本号
今天要查询自己的装的sqlserver2008 是否是R2版本，搜索了下，发现很多人查询此问题，现在记录如下，通过版本命令查询 同时也了解了哥哥sql server的对应版本好，一看就非常清晰了,记录下 1、查看 SQL Server 2005/2008 版本号 select serverproperty('productversion'