商务合作:179001057@qq.com

EXP-00091: Exporting questionable statistics解决方法

技术2022-05-11  0


某平台价值19860元的编程课程资料免费领取【点我领取】


rac2-> export NLS_LANG=AMERICAN_AMERICA.UTF8rac2-> exp hr/hr owner=hr file=hr1.dmp grants=y

Export: Release 10.2.0.1.0 - Production on Wed Jul 8 13:52:44 2009

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsExport done in UTF8 character set and AL16UTF16 NCHAR character setserver uses AL32UTF8 character set (possible charset conversion). exporting pre-schema procedural objects and actions. exporting foreign function library names for user HR . exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user HR About to export HR's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export HR's tables via Conventional Path .... . exporting table                      COUNTRIES         25 rows exportedEXP-00091: Exporting questionable statistics.. . exporting table                    DEPARTMENTS         27 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table                      EMPLOYEES        107 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table                           JOBS         19 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table                    JOB_HISTORY         10 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table                      LOCATIONS         23 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table                        REGIONS          4 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. exporting synonyms. exporting views. exporting stored procedures. exporting operators. exporting referential integrity constraints. exporting triggers. exporting indextypes. exporting bitmap, functional and extensible indexes. exporting posttables actions. exporting materialized views. exporting snapshot logs. exporting job queues. exporting refresh groups and children. exporting dimensions. exporting post-schema procedural objects and actions. exporting statisticsExport terminated successfully with warnings.rac2->

 

 

解决方法:

 

SQL> l  1* select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'SQL> /

PARAMETER------------------------------VALUE--------------------------------------------------------------------------------NLS_CHARACTERSETAL32UTF8

SQL> select * from v$nls_parameters  where parameter='NLS_CHARACTERSET';

PARAMETER----------------------------------------------------------------VALUE----------------------------------------------------------------NLS_CHARACTERSETAL32UTF8

SQL>

 

 

SQL> show parameter nls

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------nls_calendar                         stringnls_comp                             stringnls_currency                         stringnls_date_format                      stringnls_date_language                    stringnls_dual_currency                    stringnls_iso_currency                     stringnls_language                         string      AMERICANnls_length_semantics                 string      BYTEnls_nchar_conv_excp                  string      FALSEnls_numeric_characters               string

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------nls_sort                             stringnls_territory                        string      AMERICAnls_time_format                      stringnls_time_tz_format                   stringnls_timestamp_format                 stringnls_timestamp_tz_format              string

 

 

 

rac2-> export NLS_LANG=AMERICAN_AMERICA.AL32UTF8rac2-> exp hr/hr owner=hr file=hr3.dmp grants=y

Export: Release 10.2.0.1.0 - Production on Wed Jul 8 13:55:25 2009

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsExport done in AL32UTF8 character set and AL16UTF16 NCHAR character set. exporting pre-schema procedural objects and actions. exporting foreign function library names for user HR . exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user HR About to export HR's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export HR's tables via Conventional Path .... . exporting table                      COUNTRIES         25 rows exported. . exporting table                    DEPARTMENTS         27 rows exported. . exporting table                      EMPLOYEES        107 rows exported. . exporting table                           JOBS         19 rows exported. . exporting table                    JOB_HISTORY         10 rows exported. . exporting table                      LOCATIONS         23 rows exported. . exporting table                        REGIONS          4 rows exported. exporting synonyms. exporting views. exporting stored procedures. exporting operators. exporting referential integrity constraints. exporting triggers. exporting indextypes. exporting bitmap, functional and extensible indexes. exporting posttables actions. exporting materialized views. exporting snapshot logs. exporting job queues. exporting refresh groups and children. exporting dimensions. exporting post-schema procedural objects and actions. exporting statisticsExport terminated successfully without warnings.rac2->

 

 

 


最新回复(0)