在导出时有时会碰到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.
阅读(1984) | 评论(0) | 转发(0) |
