在我们做exp的过程中可能经常会遇到EXP-00091: Exporting questionable statistics.这样的EXP信息,其实它就是exp的error message,
它产生的原因是因为我们exp工具所在的操作系统环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致。
查看DB中的 NLS_CHARACTERSET:
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
---------- ----------------------------------------------------------------
NLS_CHARAC AL32UTF8
TERSET
它产生的原因是因为我们exp工具所在的操作系统环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致。
查看DB中的 NLS_CHARACTERSET:
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
---------- ----------------------------------------------------------------
NLS_CHARAC AL32UTF8
TERSET
查看操作系统中的
环境变量中的NLS_LANG
:
[oracle@MPJ~]$echo $NLS_LANG
[oracle@MPJ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@MPJ ~]$ exp \"sys/oracle as sysdba\" file=test.dmp log=test.log tables="IDL_UB1$"
Export: Release 11.2.0.3.0 - Production on Thu Jul 2 14:32:17 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table IDL_UB1$ 45623 rows exported
Export terminated successfully without warnings.
成功~
[oracle@MPJ~]$echo $NLS_LANG
[oracle@MPJ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@MPJ ~]$ exp \"sys/oracle as sysdba\" file=test.dmp log=test.log tables="IDL_UB1$"
Export: Release 11.2.0.3.0 - Production on Thu Jul 2 14:32:17 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table IDL_UB1$ 45623 rows exported
Export terminated successfully without warnings.
成功~
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29812751/viewspace-1719353/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29812751/viewspace-1719353/