导出时报:
EXP-00091: Exporting questionable statistics.
解决:这是
字符集问题:
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
设置:
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
然后再执行导出:
[RHEL3]:[/templv/oracle10]$ exp dmp/dmp file=m_exec.dmp tables=m_exec
Export: Release 10.2.0.3.0 - Production on Wed Dec 4 10:33:50 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and UTF8 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table M_EXEC 88 rows exported
Export terminated successfully without warnings.