EXP备份数据库的时候报错EXP-00091:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CCZQ
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CCZQ
About to export CCZQ's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CCZQ's tables via Conventional Path ...
. . exporting table A000000 158 rows exported
. . exporting table A5 356752 rows exported
. . exporting table AAAA 884 rows exported
. . exporting table AAA_01 6958730 rows exported
. . exporting table ABC 1132 rows exported
. . exporting table BACKINNERBASEROLEUSERINFO_HIS 216 rows exported
. . exporting table BACK_BASE_DICTIONARY 221 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table BACK_BASE_DICTIONARY_BACK 133 rows exported
. . exporting table BACK_BASE_LEVEL 9 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table BACK_BASE_USER_BASIC_INFO 87678 rows exported
EXP-00091: Exporting questionable statistics.
解決EXP-00091的方法
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL>
或者:
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'
or
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
根据上面查出的字符集来设置环境变量
WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
ok就这么简单
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CCZQ
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CCZQ
About to export CCZQ's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CCZQ's tables via Conventional Path ...
. . exporting table A000000 158 rows exported
. . exporting table A5 356752 rows exported
. . exporting table AAAA 884 rows exported
. . exporting table AAA_01 6958730 rows exported
. . exporting table ABC 1132 rows exported
. . exporting table BACKINNERBASEROLEUSERINFO_HIS 216 rows exported
. . exporting table BACK_BASE_DICTIONARY 221 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table BACK_BASE_DICTIONARY_BACK 133 rows exported
. . exporting table BACK_BASE_LEVEL 9 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table BACK_BASE_USER_BASIC_INFO 87678 rows exported
EXP-00091: Exporting questionable statistics.
解決EXP-00091的方法
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL>
或者:
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'
or
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
根据上面查出的字符集来设置环境变量
WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
ok就这么简单
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24531354/viewspace-708233/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24531354/viewspace-708233/