EXP-00091错误

lovegigi1999

在导出时有时会碰到EXP-00091错误
SQL> ! exp scott/tiger file=/tmp/scott.dmp tables=emp_copy

Export: Release 10.2.0.1.0 - Production on Fri Jul 8 10:43:20 2011

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


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

About to export specified tables via Conventional Path ...
. . exporting table                       EMP_COPY         10 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

此时需要设置nls_lang，但是要在操作系统下设置，在sql下用! export的方法无效
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
WE8ISO8859P1


SQL> ! export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

SQL>  ! exp scott/tiger file=/tmp/scott.dmp tables=emp_copy

Export: Release 10.2.0.1.0 - Production on Fri Jul 8 10:46:34 2011

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


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

About to export specified tables via Conventional Path ...
. . exporting table                       EMP_COPY         10 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@LL ~]$ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
[oracle@LL ~]$ sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 8 10:55:51 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> ! exp scott/tiger file=/tmp/scott.dmp tables=emp_copy

Export: Release 10.2.0.1.0 - Production on Fri Jul 8 10:56:00 2011

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


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

About to export specified tables via Conventional Path ...
. . exporting table                       EMP_COPY         10 rows exported
Export terminated successfully without warnings.